My Oracle Support Banner

Integrated Extract in Downstream Configuration Is Slow (Doc ID 2980570.1)

Last updated on JANUARY 05, 2024

Applies to:

Oracle GoldenGate - Version 19.1.0.0.4 and later
Information in this document applies to any platform.

Symptoms

< Configuration >
Source Database : Oracle Database 11.2.0.4
Mining Database : Oracle Database 19.20
GoldenGate : 19.20.0.0.230718 for Oracle 19C

< Symptom >
Integrated Extract in downstream configuration is slow.

The increase of SCN of Log Read Checkpoint displayed by info command is slow.

GGSCI> info <Capture>

EXTRACT    <Capture> Last Started 2023-10-02 04:14   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:07 ago)
Process ID           10645
Log Read Checkpoint  Oracle Integrated Redo Logs
                     2023-10-02 04:16:18
                     SCN 0.8537968 (8537968)

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
References


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