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

LOB_OPERATIONS1

NUMBER

The number of LOB updates (LOB writes, LOB trims, and LOB erases) applied by the inbound server.


See Also:

This note was originally conditionalized to DB122.

Oracle Database XStream Guide for more information about XStream conflict detection and resolution.

1

This column is available starting with Oracle Database 12c Release 1 (12.1.0.2).