OGG Extract TCP/IP Performance troubleshooting
(Doc ID 1428353.1)
Last updated on NOVEMBER 17, 2019
Applies to:Oracle GoldenGate - Version 10.4.0.0 to 220.127.116.11.0 [Release 10.4.0 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 06-Nov-2013***
This provides troubleshooting assistance for Extract performance issues in which a RMTTRAIL is deing written. These are some reasons you may be wanting to investigate this
1. Lag is increasing on a extract data pump when the volume of transactions may be high while writing a remote trail (RMTTRAIL)
2. A test of an extract pump to write a local trail (exttrail) does not exhibit the same lag issues when reading the same source trails.
3. Response from ggsci > SEND Extract GETTCPSTATS shows the extract pump is spending most of the time waiting to receive data
4. A diagnostic of adding the Trace parameter to your extract pump shows a lot of time spent in the summary state of Writing output records (replicate_io)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!