OGG How to address Extract Performance Issue When Reading Archive Logs stored in Oracle ASM
(Doc ID 1363266.1)
Last updated on JANUARY 22, 2018
Applies to:Oracle GoldenGate - Version 188.8.131.52 and later
Information in this document applies to any platform.
There is increasing lag on an extract and the archive logs are stored on ASM.
Using TRACE/TRACE2 will display summary stats where Extract is spending the majority of time reading records from the redo.
04:11:13.008 (+0,0,0) Redo log statistics:
04:11:13.008 (+0,0,0) 82.70% Reading record from redo log file
04:11:13.008 (+0,0,0) 8.64% Extracting subrecord from redo record
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!