STATS EXTRACT
Use STATS EXTRACT to display statistics for one or more Extract groups.
The output includes DML and DDL operations that are included in the
Oracle GoldenGate configuration.
使用STATS EXTRACT 查询一个或者一组Extract 的统计信息
包括了在参数文件中配置的对象的DDL DML 操作
To get the most accurate number of operations per second that are being
processed, do the following.
1. Issue the STATS EXTRACT command with the RESET option.
使用stats EXTRACT_NAME RESET 将最近的一次统计重置
如下：GGSCI (OGG1) 54> stats ggex
*** Total statistics since 2014-06-20 01:16:30 ***
Total inserts 6.00
Total updates 0.00
Total deletes 0.00
Total truncates 1.00
Total discards 0.00
Total operations 7.00
*** Daily statistics since 2014-06-20 01:16:30 ***
Total inserts 6.00
Total updates 0.00
Total deletes 0.00
Total truncates 1.00
Total discards 0.00
Total operations 7.00
*** Hourly statistics since 2014-06-20 19:00:00 ***
Total inserts 2.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 2.00
*** Latest statistics since 2014-06-20 19:25:29 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
GGSCI (OGG1) 55> stats ggex rese
Sending STATS request to EXTRACT GGEX ...
Successfully reset statistics.
GGSCI (OGG1) 56> stats ggex
Sending STATS request to EXTRACT GGEX ...
Start of Statistics at 2014-06-20 19:31:31.
Output to /u01/ogg/dirdat/kt:
Extracting from GG.SEND to GG.SEND:
*** Total statistics since 2014-06-20 01:16:30 ***
Total inserts 6.00
Total updates 0.00
Total deletes 0.00
Total truncates 1.00
Total discards 0.00
Total operations 7.00
*** Daily statistics since 2014-06-20 01:16:30 ***
Total inserts 6.00
Total updates 0.00
Total deletes 0.00
Total truncates 1.00
Total discards 0.00
Total operations 7.00
*** Hourly statistics since 2014-06-20 19:00:00 ***
Total inserts 2.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 2.00
*** Latest statistics since 2014-06-20 19:30:55 ***
No database operations have been performed.---------此处已经清空统计
End of Statistics.
在源库插入一条数据
insert into send values (105);
再查询统计信息：
GGSCI (OGG1) 57> stats ggex
Sending STATS request to EXTRACT GGEX ...
Start of Statistics at 2014-06-20 19:37:23.
Output to /u01/ogg/dirdat/kt:
Extracting from GG.SEND to GG.SEND:
*** Total statistics since 2014-06-20 01:16:30 ***
Total inserts 7.00
Total updates 0.00
Total deletes 0.00
Total truncates 1.00
Total discards 0.00
Total operations 8.00
*** Daily statistics since 2014-06-20 01:16:30 ***
Total inserts 7.00
Total updates 0.00
Total deletes 0.00
Total truncates 1.00
Total discards 0.00
Total operations 8.00
*** Hourly statistics since 2014-06-20 19:00:00 ***
Total inserts 3.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 3.00
*** Latest statistics since 2014-06-20 19:30:55 ***-——已经捕获到这条插入信息
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
End of Statistics.
2. Issue the STATS EXTRACT REPORTRATE command. The LATEST STATISTICS
field shows the operations per second.
STATS EXTRACT REPORTRATE 命令
NOTE: The actual number of DML operations executed on a DB2 database
might not match the number of extracted DML operations reported by
Oracle GoldenGate. DB2 does not log update statements if they do not
physically change a row, so Oracle GoldenGate cannot detect them or
include them in statistics.
Syntax:
STATS EXTRACT
[,
[, TABLE