How to fix the Oracle error ORA-23603: string enqueue aborted due to low SGA?

In this post, you’ll learn more about the Oracle ErrorORA-23603: string enqueue aborted due to low SGA with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-23603: string enqueue aborted due to low SGA

Reason for the Error ORA-23603: string enqueue aborted due to low SGA

An attempt to enqueue a GoldenGate, XStream or Streams message was aborted because ORACLE is running low on memory allotted.

How to fix the Error ORA-23603: string enqueue aborted due to low SGA ?

You can fix this error in Oracle by following the below steps

Either start consuming messages by enabling any GoldenGate, XStream or Streams propagation or apply which might be disabled. An alternative is to allot more memory to STREAMS, which can be done by increasing the streams_pool_size initialization parameter if one was defined or by increasing the shared_pool_size.