Integrated Replicat with Oracle shows lag processing DML on table with SDO datatype

(Doc ID 1923109.1)

Last updated on JANUARY 17, 2018

Applies to:

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





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 hundreds of Community platforms