I have configured oracle goldengate integrated capture process using the default values. As the data load increases I see that extract starts lagging behind by an hour (or more) and database performance degrades. How you will resolve this performance issue?
Answer Posted / Varsha Choudhary
To resolve the performance issue, you can consider tuning the parameters such as batch size, buffer size, and transaction size. You may also need to optimize your database configuration, such as increasing the shared pool size or using adaptive cursor sharing.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category