Oracle 视图 V$GOLDENGATE_TABLE_STATS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$GOLDENGATE_TABLE_STATS表示由GoldenGate收集的表级静态和动态统计信息。它用于查看从源数据表传输的数据量大小，以及传输时序。
该视图可以用如下SQL语句查询：
SELECT scn, to_timestamp(last_refreshed) last_refreshed, capture_name, source_schema, target_schema, source_table, target_table, target_rows_delta, target_volume_mb_delta
FROM v$goldengate_table_stats
WHERE last_refreshed >= SYSDATE – 1
ORDER BY last_refreshed;
官方英文解释
V$GOLDENGATE_TABLE_STATS displays table statistics for all the tables used by each Oracle GoldenGate apply server.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Name of the apply process |
|
|
|
Parallel apply server slave ID |
|
|
|
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 the last update of the statistics |
|
|
|
Number of insert operations on this table processed by this apply server |
|
|
|
Number of update operations on this table processed by this apply server |
|
|
|
Number of delete operations on this table processed by this apply server |
|
|
|
Number of insert collisions on this table encountered by this apply server |
|
|
|
Number of update collisions on this table encountered by this apply server |
|
|
|
Number of delete collisions on this table encountered by this apply server |
|
|
|
Number of change records that resulted in an error that were recorded on this table by this apply server |
|
|
|
Number of change records that resulted in an error that were ignored on this table by this apply server |
|
|
|
Number of waits for this table due to dependency |
|
|
|
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. |
