18.104.22.168 Integrated Replicat with Oracle 22.214.171.124 shows lag processing DML on table with SDO datatype
(Doc ID 1923109.1)
Last updated on FEBRUARY 25, 2019
Applies to:Oracle GoldenGate - Version 126.96.36.199.0 and later
Oracle Database - Enterprise Edition - Version 188.8.131.52 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
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