My Oracle Support Banner

Integrated Replicat Stats Command output description (Doc ID 2062132.1)

Last updated on APRIL 09, 2020

Applies to:

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

Goal

Qn1:It appears that in the Goldengate manuals, explanations for the columns output by the STATS command are not explained. Please provide an explantation for the following:

"Redirected", "Datatype functionality", "Event actions" and "Direct transactions ratio"

Integrated Replicat Statistics:

Total transactions 13.00
Redirected 0.00
DDL operations 0.00
Stored procedures 0.00
Datatype functionality 0.00
Event actions 0.00
Direct transactions ratio 0.00%
 
Qn2:One last question and I think we can consider this resolved. As far as "Total insert collisions" is that the number of operations handled by the handle collisions parameter where if found no row and turned an update into an insert?

*** Latest statistics since 2015-08-31 13:45:16 ***
  Total inserts 18679934.00
  Total updates 20172779.00
  Total deletes 1278892.00
  Total discards 0.00
  Total operations 40131605.00
  Total insert collisions 1.00
 

Solution

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
Goal
Solution


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