Oracle 视图 DBA_HIST_REPLICATION_TBL_STATS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_HIST_REPLICATION_TBL_STATS用于确定复制传输的表的状态。可以在ASE平台的维护工作中查看表之间复制的情况，以检测传输状况是否健康，明确大量传输不健康的表。
它还具有查询复制运行状况的功能，可以查看每张表上一次成功复制事件发生时间，以及每个表上复制事务累计数量。在N和P两方数据库之间有很多数据传输时，这样就可以查出哪些表的传输健康，哪些不健康。
使用Oracle视图DBA_HIST_REPLICATION_TBL_STATS时，可以使用联接操作查询其中的信息，也可以通过DBA_HIST_SNAPSHOT视图查询基于SNAPSHOT的信息。
如下所示的查询可以检索DBA_HIST_REPLICATION_TBL_STATS视图中的数据：
SELECT TABLE_NAME，SNAP_ID，TIME ，TOTAL_UPDATES
FROM
DBA_HIST_REPLICATION_TBL_STATS，
DBA_HIST_SNAPSHOT
WHERE
DBA_HIST_REPLICATION_TBL_STATS.SNAP_ID =
DBA_HIST_SNAPSHOT.SNAP_ID;
官方英文解释
DBA_HIST_REPLICATION_TBL_STATS displays replication table statistics for Oracle GoldenGate and XStream sessions. This view is intended for use with Automatic Workload Repository (AWR).
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Unique snapshot ID |
|
|
|
|
Database ID for the snapshot |
|
|
|
|
Instance number for the snapshot |
|
|
|
|
Name of the apply process |
|
|
|
|
Name of the table |
|
|
|
|
Owner of the table |
|
|
|
|
Session module. Valid values:
|
|
|
|
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 successfully resolved conflicts |
|
|
|
|
Number of conflicts that could not be resolved due to an error during resolution |
|
|
|
|
The total number of errors for the replication operation |
|
|
|
|
Number of collisions on this table handled by this apply server |
|
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
|
The ID of the container that
|
