My Oracle Support Banner

INSERTUPDATES and INSERTDELETES shows in Replicat STATS as UPDATE and DELETE Ops (Doc ID 2404090.1)

Last updated on MARCH 08, 2019

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 <SCHEMA>.<TABLE NAME> to <SCHEMA>.<TABLE NAME>:

*** 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 <SCHEMA>.<TABLE NAME> to <SCHEMA>.<TABLE NAME>:

*** 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

 

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References

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