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 AUGUST 04, 2018

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.