|
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)
(以上内容不代表本站观点。) --------------------------------- |
本網站是"非商業"(non-commercial)。
