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 JANUARY 17, 2018

Applies to:

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

 

Changes

 

Cause

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