Extracting DML Stats/Workload With GoldenGate

1. Reset Counters/Stats:

2. Retrieve Stats for a Table Since Reset:

3. Retrieve Stats Total Since the Last Start of Extract:

4. Retrieve Stats from the Day of a Table:

5. Retrieve Stats from the Day of All Schema Tables Configured on Extract:

Example Output

GGSCI (myserver.local) 1> stats ext_test total daily
 
 Sending STATS request to EXTRACT EXT_TEST ...
 
 Start of Statistics at 2019-12-16 15:21:56.
 
 Output by User Exit:
 
 Extracting from OWNER1.TABLE1 to OWNER1.TABLE1:
 
 *** Total statistics since 2019-12-16 07:18:14 ***
  Total inserts 2744.00
  Total updates 0.00
  Total deletes 300.00
  Total discards 0.00
  Total operations 3044.00
 
 *** Daily statistics since 2019-12-16 07:18:14 ***
  Total inserts 2744.00
  Total updates 0.00
  Total deletes 300.00
  Total discards 0.00
  Total operations 3044.00