ITPub博客

首页 > 数据库 > Oracle > OGG Get Error "Statistics reply buffer exceeded. Results truncated..."

OGG Get Error "Statistics reply buffer exceeded. Results truncated..."

原创 Oracle 作者:linfeng_oracle 时间:2014-05-23 15:03:33 0 删除 编辑

OGG Get Error "Statistics reply buffer exceeded. Results truncated..." (文档 ID 1347837.1)


In this Document


 Symptoms

 Cause

 Solution

 References



Applies to:
 Oracle GoldenGate - Version 4.0.0 and later
Information in this document applies to any platform.

Symptoms

When I run STATS command, the result is truncated with error message.


"Statistics reply buffer exceeded. Results truncated..."

Cause

This is a limitation of the statistics reply buffer.  Excessive messaging back to GGSCI could cause latency in the extract/replicat process. When the reply buffer exceeds approximately 30000 bytes (minus the size of the error message) then that warning message is displayed. Currently, there is no way to increase the statistics reply buffer.

Enhancement Request 9430363 "STATISTICS REPLY BUFFER EXCEEDED" has been logged for this.

Solution

A workaround would be to split the stats by group of tables. Example:


stats extract e1, table .A*
stats extract e1, table .B*
stats extract e1, table .C*


If it is not required that the stats be obtained through the screen interface, an alternative is available:


Ggsci> send , report

 

The entire stats would be available in the report.

This could also be used in conjunction with a report rollover and a reset of statistics.

This could be scripted and the results could be grepped. There would be no practical limit on the size of the returned data.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24996904/viewspace-1168354/,如需转载,请注明出处,否则将追究法律责任。

下一篇: oracle回收高水位
请登录后发表评论 登录
全部评论

注册时间:2011-09-14

  • 博文量
    76
  • 访问量
    415614