In GoldenGate when using "stats extract group_name" you may get this error when the ouptut is too big to fit in the buffer:
"Statistics reply buffer exceeded. Results truncated..."
You can write the statistics to a report file like below for the entire group stats:
GGSCI (ndhdbp3) 18> send epcs07, report
Sending REPORT request to EXTRACT EPCS07 ...
Request processed.
Or use stats extract group_name, table owner.table_name(or *) to get stats on individual table or schema.
"Statistics reply buffer exceeded. Results truncated..."
You can write the statistics to a report file like below for the entire group stats:
GGSCI (ndhdbp3) 18> send epcs07, report
Sending REPORT request to EXTRACT EPCS07 ...
Request processed.
Or use stats extract group_name, table owner.table_name(or *) to get stats on individual table or schema.
No comments:
Post a Comment