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

ORA-22320: missing user version string

1 Answers  


ORA-02436: date or system variable wrongly specified in CHECK constraint

1 Answers  


ORA-01678: parameter string must be pairs of pattern and replacement strings

1 Answers  


EXP-00082: Invalid function name passed to procedural object support: string

1 Answers  


ORA-24308: illegal define position

1 Answers  






ORA-31507: %s parameter value longer than maximum length string

1 Answers  


ORA-24087: Invalid database user string

1 Answers  


RMAN-11004: format requires %%c when duplexing

1 Answers  


PLS-00116: Duplicate where-clause in table expression

1 Answers  


SQL-02124: NULL value returned by EXEC TOOLS statement

1 Answers  


ORA-16631: Operation requires shutdown of database/instance "string"

1 Answers  


ORA-12821: invalid value for INSTANCES

1 Answers  


Categories