OGG How to address Extract Performance Issue When Reading Archive Logs stored in Oracle ASM
(Doc ID 1363266.1)
Last updated on DECEMBER 30, 2019
Applies to:
Oracle GoldenGate - Version 9.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
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.
SUMMARY STATISTICS
.
.
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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |