7.259 V$GOLDENGATE_TABLE_STATS
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. |