Oracle教程 2023-03-31

Oracle 视图 V$XSTREAM_TABLE_STATS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图V$XSTREAM_TABLE_STATS可以对XStream系统中表的所有操作和状态进行详细的统计分析，从而了解XStream数据实时迁移的过程情况，确定表的迁移状态、迁移消耗的时间量以及单次同步的消耗量等信息。

使用时可以执行一句简单的SQL，如：

SELECT * FROM v$xstream_table_stats;

来查看V$XSTREAM_TABLE_STATS视图中各个字段的数据，例如TABLE_NAME 列，可以查看具体发生迁移的表名；FROM_TNS 和TO_TNS 列可以查看迁移的源目标地点；STATUS列可以查看当前的表的迁移状态；SYN_COUNT列可以查看迁移的次数；PERIOD_SECOND列可以查看每次同步耗费的时间量，以此等等。

官方英文解释

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

Column	Datatype	Description
`APPLY_NAME`	`VARCHAR2(128)`	Name of XStream Out or XStream 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(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(128)`	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_OPERATIONS`	`NUMBER`	The number of LOB updates (LOB writes, LOB trims, and LOB erases) applied by the inbound server.

本站中文解释

官方英文解释

相关推荐