SYS.V$CACHE_GROUP_LOG_STATS

This view is specific to log-based read-only cache groups. It contains statistics about DML operations that the Golden Gate Replicat process has run and applied to the parent table of the cache group. There is one row per log-based cache group as defined by the CACHE_GROUP_OWNER, CACHE_GROUP_NAME pair in the database.

Columns

Column name	Type	Description
CACHE_GROUP_OWNER	VARCHAR2 (30) INLINE	Cache group owner.
CACHE_GROUP_NAME	VARCHAR2 (30) INLINE	Name of the cache group.
NUMINSERTS	TT_BIGINT	Number of inserts that Golden Gate successfully applied into the cache group's parent table.
NUMUPDATES	TT_BIGINT	Number of updates that Golden Gate successfully applied into the cache group's parent table.
NUMDELETES	TT_BIGINT	Number of deletes that Golden Gate successfully applied into the cache group's parent table.
NUMNOOPS	TT_BIGINT	Number of DML operations that were older than the row being affected in the parent table and were therefore ignored (noop operations).
NUMLOADWAITS	TT_BIGINT	Number of DML operations that were newer than ongoing dynamic loads and waited for such ongoing dynamics loads to complete.
ELEMENTID	TT_INTEGER NOT NULL	Unused. Ignore this value.