V$XSTREAM_TABLE_STATS
shows the statistics for all the tables processed by each apply server for the current session.
Column | Datatype | Description |
---|---|---|
|
|
Name of XStream Out or In process |
|
|
Parallel apply server slave ID. If the server ID is |
|
|
Source owner of the captured or replicated table |
|
|
Source name of the captured or replicated table |
|
|
Target owner of the captured or replicated table |
|
|
Target name of the captured or replicated table |
|
|
Time of last update |
|
|
Number of insert operations on this table processed by this apply server for the current session |
|
|
Number of update operations on this table processed by this apply server for the current session |
|
|
Number of delete operations on this table processed by this apply server for the current session |
|
|
Number of insert collisions on this table encountered by this apply server for the current session |
|
|
Number of update collisions on this table encountered by this apply server for the current session |
|
|
Number of delete collisions on this table encountered by this apply server for the current session |
|
|
Number of change records that were recorded on this table by this apply server for the current session |
|
|
Number of ignored change records on this table by this apply server for the current session |
|
|
Number of waits for this table due to dependency for the current session |
|
|
The ID of the container to which the data pertains. Possible values include:
|
|
|
Number of conflicts where an insert gets an ORA-00001 error |
|
|
Number of conflicts where an update gets an ORA-26786 error |
|
|
Number of conflicts where an update gets an ORA-26787 error |
|
|
Number of conflicts where a delete gets an ORA-26786 error |
|
|
Number of conflicts where a delete gets an ORA-26787 error |
|
|
Number of successfully resolved conflicts |
|
|
Number of conflicts that could not be resolved due to an error during resolution |
|
|
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.
This column is available starting with Oracle Database 12c Release 1 (12.1.0.2).