My Oracle Support Banner Integrated Replicat with Oracle shows lag processing DML on table with SDO datatype (Doc ID 1923109.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle GoldenGate - Version and later
Oracle Database - Enterprise Edition - Version 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.


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



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

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