INSERTUPDATES and INSERTDELETES shows in Replicat STATS as UPDATE and DELETE Ops

(Doc ID 2404090.1)

Last updated on MAY 29, 2018

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 and later
Information in this document applies to any platform.

Symptoms

Integrated Replicat Insert Updates/Deletes show as inserts and not updates/deletes in the stats, whereas Classic Replicat shows them as
updates/deletes in the stats.

 

Replicating from MST_DC_DBO.DC_ACCOUNT to DCS00DBO.T_SC4DA_DC_ACCOUNT:

*** Total statistics since 2017-12-07 02:18:23 ***
Total inserts 1039599.00
Total updates 3841976.00
Total deletes 0.00
Total discards 0.00
Total operations 4881575.00

Replicating from MST_DC_DBO.DC_ACCOUNT to DCS00DBO.T_GSC4DA_DC_ACCOUNT:

*** Total statistics since 2017-12-07 02:18:23 ***
Total inserts 4881575.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4881575.00

 

 

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