GGSCI (OGG1) 48> help stats extract
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
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26764973/viewspace-1189830/,如需转载,请注明出处,否则将追究法律责任。
请登录后发表评论
登录
全部评论
<%=items[i].createtime%>
<%=items[i].content%>
<%if(items[i].items.items.length) { %>
<%for(var j=0;j
<%}%> <%if(items[i].items.total > 5) { %>
<%}%> <%}%>
<%=items[i].items.items[j].createtime%>
<%=items[i].items.items[j].username%> 回复 <%=items[i].items.items[j].tousername%>: <%=items[i].items.items[j].content%>
还有<%=items[i].items.total-5%>条评论
) data-count=1 data-flag=true>点击查看
<%}%>
最新文章
- mysql 5.7 新特性中在线in-place 修改字段的大小
- ORACLE 11G 静默安装soft db listener
- vsphere 虚拟机在线添加磁盘linux
- linux 缩减LV大小
- Removed unused HAIP route: 169.254.95.0 / 255.255.255.0 / 0.0.0.0 / usb0
- ORA-600:[kcbzwfcro_2] Reported in Alert.log (文档 ID 2085507.1)
- WRH$_ACTIVE_SESSION_HISTORY
- 索引重建的必要性与影响 (Doc ID 1525787.1)
- ORACLE 11g R2 RAC 11.2.0.2.12 PSU 安装升级
- List of Oracle Database Patch Set Updates (PSU)
转载于:http://blog.itpub.net/26764973/viewspace-1189830/