ttCacheLogStats

This procedure returns statistics on the changes made by GoldenGate to the specified log-based cache group. If no cache group is specified, all cache groups are displayed.

Required Privilege

This procedure requires the TTPRIV_NONE privilege.

Related Views

This procedure has this related view.

SYS.V$CACHE_GROUP_LOG_STATS

Syntax

ttCacheLogStats('cache_group_owner', 'cache_group_name')

Parameters

ttCacheLogStats has these parameters:

Parameter	Type	Description
`cache_group_owner`	`TT_VARCHAR2(30)`	Cache group owner.
`cache_group_name`	`TT_VARCHAR2(30) NOT NULL`	The name of the cache group.

Result Set

ttCacheLogStats returns the results:

Column	Type	Value
`cache_group_owner`	`VARCHAR2(30)`	Cache group owner.
`cache_group_name`	`VARCHAR2(30)`	Name of the cache group.
`numInserts`	`TT_BIGINT`	Number of inserts that GoldenGate successfully applied into the cache group's parent table.
`numUpdates`	`TT_BIGINT`	Number of updates that GoldenGate successfully applied into the cache group's parent table.
`numDeletes`	`TT_BIGINT`	Number of deletes that GoldenGate 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.

Examples

Command> CALL ttCacheLogStats('HR', 'EMP_CACHE');
<HR, EMP_CACHE, 1523, 874, 212, 18, 3>
1 row found.

For all cache groups:

Command> CALL ttCacheLogStats();
  CACHE_GROUP_OWNER: HR
  CACHE_GROUP_NAME: EMP_CACHE
  NUMINSERTS: 1523
  NUMUPDATES: 874
  NUMDELETES: 212
  NUMNOOPS: 18
  NUMLOADWAITS: 3

  CACHE_GROUP_OWNER: CACHEADMIN
  CACHE_GROUP_NAME: CGT1
  NUMINSERTS: 0
  NUMUPDATES: 2
  NUMDELETES: 2
  NUMNOOPS: 2
  NUMLOADWAITS: 0

2 rows found.