Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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?



I have configured oracle goldengate integrated capture process using the default values. As the data..

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

Post New Answer

More Oracle GoldenGate Interview Questions

how do you create a csv file from the extracted data?

1 Answers   Oracle,


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?

1 Answers   Oracle,


what type of encryption is supported in goldengate?

1 Answers   Oracle,


what is a credential store in ogg 12c?

1 Answers   Oracle,


I want to configure multiple extracts to write to the same exttrail file? Is this possible?

1 Answers   Oracle,


what is the passthru mode used for?

1 Answers   Oracle,


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?

1 Answers   Oracle,


what are some of the key features of goldengate 12c?

1 Answers   Oracle,


what databases supports goldengate integrated delivery?

1 Answers   Oracle,


how do you view the data which has been extracted from the redo logs?

1 Answers   Oracle,


how do you retrieve information from the oracle credential store?

1 Answers   Oracle,


what are the different data encryption methods available in ogg 12c?

1 Answers   Oracle,


Categories