Integrated Replicat Stats Command output description

(Doc ID 2062132.1)

Last updated on APRIL 06, 2017

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

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