Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$XSTREAM_TABLE_STATS

V$XSTREAM_TABLE_STATS shows the statistics for all the tables processed by each apply server for the current session.

Column Datatype Description
APPLY_NAME VARCHAR2(30) Name of XStream Out or In process
SERVER_ID NUMBER Parallel apply server slave ID. If the server ID is 0, then this is an aggregate of statistics for servers that may have been automatically shutdown due to session inactivity.
SOURCE_TABLE_OWNER VARCHAR2(30) Source owner of the captured or replicated table
SOURCE_TABLE_NAME VARCHAR2(30) Source name of the captured or replicated table
DESTINATION_TABLE_OWNER VARCHAR2(30) 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 last update
TOTAL_INSERTS NUMBER Number of insert operations on this table processed by this apply server for the current session
TOTAL_UPDATES NUMBER Number of update operations on this table processed by this apply server for the current session
TOTAL_DELETES NUMBER Number of delete operations on this table processed by this apply server for the current session
INSERT_COLLISIONS NUMBER Number of insert collisions on this table encountered by this apply server for the current session
UPDATE_COLLISIONS NUMBER Number of update collisions on this table encountered by this apply server for the current session
DELETE_COLLISIONS NUMBER Number of delete collisions on this table encountered by this apply server for the current session
REPERROR_RECORDS NUMBER Number of change records that were recorded on this table by this apply server for the current session
REPERROR_IGNORES NUMBER Number of ignored change records on this table by this apply server for the current session
WAIT_DEPENDENCIES NUMBER Number of waits for this table due to dependency for the current session
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