STREAMS Health Check Errors
edited Jan 8, 2013 12:57AM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered ✓
Hello,
we have run the STREAMS Health Check and we have the followings warnings/errors:
we have run the STREAMS Health Check and we have the followings warnings/errors:
ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 50000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 32
ORA-06512: at "SYS.DBMS_OUTPUT", line 97
ORA-06512: at "SYS.DBMS_OUTPUT", line 112
ORA-06512: at line 185
++
++ Performance Checks ++
++
+ WARNING: The queue 'STRADM'.'SGD_PK1_CDBCS_SQ' has spilled 43% of its messages!
+ Since the queue has been started, some large ratio of messages
+ have been spilled to disk. If no errors have occurred which might
+ have caused the spills in the past (such as an aborted Apply or
+ Propagation process), and if you do not have long running transactions
0