關於OGG的stats 進程名 reset命令，oggstatsreset命令

關於OGG的stats 進程名 reset命令，oggstatsreset命令

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:04Copyright (C) 1995, 2011, 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 2015-04-18 18:13:03.Output to /u02/ggs/dirdat/qd:Extracting from USERA.TABA to USERA.TABA:*** Total statistics since 2015-04-18 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 2015-04-18 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 2015-04-18 18:00:00 ***        No database operations have been performed.*** Latest statistics since 2015-04-18 18:12:46 ***        No database operations have been performed.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      00:00:06    EXTRACT     RUNNING     EXTQD       00:00:00      00:00:04    GGSCI (gg321) 25>----------------中間進行DML操作---------------------------------GGSCI (gg321) 27> stats extqdSending STATS request to EXTRACT EXTQD ...Start of Statistics at 2015-04-18 18:27:19.Output to /u02/ggs/dirdat/qd:Extracting from USERA.TABA to USERA.TABA:*** Total statistics since 2015-04-18 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 2015-04-18 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 2015-04-18 18:00:00 ***        Total inserts                                5.00        Total updates                                1.00        Total befores                                1.00        Total deletes                                0.00        Total discards                               0.00        Total operations                             7.00*** Latest statistics since 2015-04-18 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> 

說白了，關於OGG的stats 進程名 reset命令 的作用是：reset了Hourly statistics 和  Latest statistics，以便能明確的統計出 reset 之後 ogg捕捉到的DML變化情況。

參考文章：

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)