About the OGG stats process name reset command, the oggstatsreset command
Oracle GoldenGate Command Interpreter for OracleVersion 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 Linux, x86, 32bit (optimized), Oracle 10g on Oct 4 2011 23: 54: 04 Copyright (C) 1995,201 1, oracle and/or its affiliates. all rights reserved. GGSCI (gg321) 22> stats extqd resetSending STATS request to extract extqd... successfully reset statistics. GGSCI (gg321) 23> stats extqdSending STATS request to extract extqd... start of Statistics at 18:13:03. output to/u02/ggs/dirdat/qd: Extracting from USERA. TABA to USERA. TABA: * ** Total statistics since 17:38:42 *** Total inserts 0.00 Total updates 2.00 Total befores 1.00 Total deletes 5.00 Total discards 0.00 Total operations 8.00 *** Daily statistics since 17:38:42 *** total inserts 0.00 Total updates 2.00 Total befores 1.00 Total deletes 5.00 Total discards 0.00 Total operations 8.00 *** Hourly statistics since 18:00:00 *** No database operations have been completed MED. * ** Latest statistics since 18:12:46 *** No database operations have been saved med. end of Statistics. GGSCI (gg321) 24> info allProgram Status Group Lag Time Since ChkptMANAGER running extract abended dpora 00:00:00 21164: 45: 27 extract running dpqd 00:00:00 00:00:02 extract running extora 00:00:00 extract running extqd 00:00:06 GGSCI (gg321) 25> ---------------- perform DML operations in the middle mongoggsci (gg321) 27> stats extqdSending STATS request to extract extqd... start of Statistics at 18:27:19. output to/u02/ggs/dirdat/qd: Extracting from USERA. TABA to USERA. TABA: * ** Total statistics since 17:38:42 *** Total inserts 5.00 Total updates 3.00 Total befores 2.00 Total deletes 5.00 Total discards 0.00 Total operations 15.00 *** Daily statistics since 17:38:42 *** total inserts 5.00 Total updates 3.00 Total befores 2.00 Total deletes 5.00 Total discards 0.00 Total operations 15.00 *** Hourly statistics since 18:00:00 *** Total inserts 5.00 Total updates 1.00 Total befores 1.00 deletes 0.00 Total discards 0.00 Total operations 7.00 *** Latest statistics since 18:12:46 *** Total inserts 5.00 Total updates 1.00 Total befores 1.00 Total deletes 0.00 Total discards 0.00 Total operations 7.00End of Statistics. GGSCI (gg321) 28>
To put it bluntly, the role of the stats process name reset command of OGG is: reset the Hourly statistics and Latest statistics, so as to clearly count the DML changes captured by ogg after reset.
References:
How To Display Interim Runtime Statistics for OGG Process (Doc ID 1310087.1)How To Generate Interim Runtime Statistics for OGG Process (Doc ID 1310095.1)