ORA-23603 'STREAMS enqueue aborted due to low SGA' Error from Streams Propagation, and V$STREAMS_CAPTURE.STATE Hanging on 'Enqueuing Message'
Last updated on OCTOBER 30, 2013
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]Information in this document applies to any platform.
Symptoms
Streams propagation between two 10.2 databases keeps halting with error:
ORA-23603: STREAMS enqueue aborted due to low SGA
Increasing memory available to Streams helps for a short time - messages start flowing, but then everything
stops again and propagation fails with the same ORA-23603 error. Memory allocated to Streams is excessive, yet the problem continues. The state of the capture process according to V$STREAMS_CAPTURE is 'Enqueuing Message'.
This note is only intended to discuss one potential cause of the ORA-23603 error: the initialization parameter AQ_TM_PROCESSES being explicitly set to '0'. Please note that there are reasons that an ORA-23603 error can occur, such as inadequate memory or excessive queue spilling, but these reasons are not treated in this note.
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms