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 / 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 |
how do you create a csv file from the extracted data?
my extract was running fine for a long time. All of a sudden it went down. I started the extract processes after 1 hour. What will happen to my committed transactions that occurred in the database during last 1 hour?
what type of encryption is supported in goldengate?
what is a credential store in ogg 12c?
I want to configure multiple extracts to write to the same exttrail file? Is this possible?
what is the passthru mode used for?
we want to setup one-way data replication for my online transaction processing application. However there are compressed tables in the environment. Please suggest how I can achieve it?
what are some of the key features of goldengate 12c?
what databases supports goldengate integrated delivery?
how do you view the data which has been extracted from the redo logs?
how do you retrieve information from the oracle credential store?
what are the different data encryption methods available in ogg 12c?