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 DECEMBER 10, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 220.127.116.11 [Release 10.1 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document