My Oracle Support Banner

12.1.2.0 Integrated Replicat with Oracle 11.2.0.4 shows lag processing DML on table with SDO datatype (Doc ID 1923109.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 and later
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Oracle GoldenGate (OGG) Integrated Replicat (IR) lag is observed when processing DML on tables with columns of datatype MDSYS.SDO_GEOMETRY.  Lag is observed even if the DML doesn't include the SDO column.  IR statistics included in a Replicat report file show a high percentage for 'Direct transaction ratio'.  For example:

Integrated Replicat Statistics:

           Total transactions:      2831
                   Redirected:         0
               DDL operations:         0
            Stored procedures:         0
       Datatype functionality:      1305
                Event actions:         0
    Direct transactions ratio:        46%       <========   high percentage

In addition, the Integrated Replicate inbound server / apply receiver may frequently be in state "Waiting for Replicat flush request to complete".  This may be noted in an OGG Integrated Extract and Integrated Replicat health check output (see <Note 1448324.1>).

 

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