V$GOLDENGATE_TABLE_STATS

V$GOLDENGATE_TABLE_STATS displays table statistics for all the tables used by each Oracle GoldenGate apply server.

Column Datatype Description
APPLY_NAME VARCHAR2(128) Name of the apply process
SERVER_ID NUMBER Parallel apply server worker ID
SOURCE_TABLE_OWNER VARCHAR2(128) Source owner of the captured or replicated table
SOURCE_TABLE_NAME VARCHAR2(128) Source name of the captured or replicated table
DESTINATION_TABLE_OWNER VARCHAR2(128) Target owner of the captured or replicated table
DESTINATION_TABLE_NAME VARCHAR2(30) Target name of the captured or replicated table
LAST_UPDATE DATE Time of the last update of the statistics
TOTAL_INSERTS NUMBER Number of insert operations on this table processed by this apply server
TOTAL_UPDATES NUMBER Number of update operations on this table processed by this apply server
TOTAL_DELETES NUMBER Number of delete operations on this table processed by this apply server
INSERT_COLLISIONS NUMBER Number of insert collisions on this table encountered by this apply server
UPDATE_COLLISIONS NUMBER Number of update collisions on this table encountered by this apply server
DELETE_COLLISIONS NUMBER Number of delete collisions on this table encountered by this apply server
REPERROR_RECORDS NUMBER Number of change records that resulted in an error that were recorded on this table by this apply server
REPERROR_IGNORES NUMBER Number of change records that resulted in an error that were ignored on this table by this apply server
WAIT_DEPENDENCIES NUMBER Number of waits for this table due to dependency
CON_ID NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

CDR_INSERT_ROW_EXISTS NUMBER Number of conflicts where an insert gets an ORA-00001 error
CDR_UPDATE_ROW_EXISTS NUMBER Number of conflicts where an update gets an ORA-26786 error
CDR_UPDATE_ROW_MISSING NUMBER Number of conflicts where an update gets an ORA-26787 error
CDR_DELETE_ROW_EXISTS NUMBER Number of conflicts where a delete gets an ORA-26786 error
CDR_DELETE_ROW_MISSING NUMBER Number of conflicts where a delete gets an ORA-26787 error
CDR_SUCCESSFUL_RESOLUTIONS NUMBER Number of successfully resolved conflicts
CDR_FAILED_RESOLUTIONS NUMBER Number of conflicts that could not be resolved due to an error during resolution
LOB_OPERATIONS NUMBER The number of LOB updates (LOB writes, LOB trims, and LOB erases) applied by the inbound server.