ORA-23603 'STREAMS enqueue aborted due to low SGA' Error from Streams Propagation, and V$STREAMS_CAPTURE.STATE Hanging on 'Enqueuing Message' (Doc ID 745601.1)

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