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.