关于OGG的stats 进程名 reset命令

最新推荐文章于 2022-05-04 16:13:46 发布

msdnchina

最新推荐文章于 2022-05-04 16:13:46 发布

阅读量4.2k

点赞数

分类专栏： Oracle GoldenGate

本文链接：https://blog.csdn.net/msdnchina/article/details/45032521

版权

Oracle GoldenGate 专栏收录该内容

101 篇文章 0 订阅

订阅专栏

Oracle GoldenGate Command Interpreter for Oracle
Version 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, 2011, Oracle and/or its affiliates. All rights reserved.


GGSCI (gg321) 22> stats extqd reset

Sending STATS request to EXTRACT EXTQD ...

Successfully reset statistics.


GGSCI (gg321) 23> stats extqd

Sending 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 all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     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 extqd

Sending 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.00

End 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)