My Oracle Support Banner

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 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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.