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 184.108.40.206 [Release 10.1 to 11.2]
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms