ORA-23603: STREAMS enqueue aborted due to low SGA



ORA-23603: STREAMS enqueue aborted due to low SGA..

Answer / guest

Cause: An attempt to enqueue a STREAMS message was aborted
because ORACLE is running low on memory allotted for STREAMS.

Action: Either start consuming messages by enabling any
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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCC-01401: Your Pro*Pascal authorization is about to expire

1 Answers  


SQL*Loader-00527: OCI return status: no data

1 Answers  


ORA-06931: CMX: error during read_properties for server

1 Answers  


ORA-02287: sequence number not allowed here

1 Answers  


PCB-00236: Cannot use PIC N/G variable. NLS_NCHAR not set or set incorrectly.

1 Answers  






TNS-00076: component by specifying the component name in

1 Answers  


SQL*Loader-00478: unable to continue due to missing filename for LOBFILE or SDF

1 Answers  


PCC-02401: Host variable arrays of this type are currently not supported

1 Answers  


ORA-27149: assignment out of range

1 Answers  


ORA-31206: DBMS_LDAP: PL/SQL - Invalid LDAP search scope.

1 Answers  


TNS-03512: Used string adapter to resolve the alias

1 Answers  


ORA-38495: data type for the stored attribute string is inconsistent.

1 Answers  


Categories