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-25010: Invalid nested table column name in nested table clause

1 Answers  


ORA-23342: invalid parameter column string

1 Answers  


PCB-00008: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL

1 Answers  


ORA-14011: names assigned to resulting partitions must be distinct

1 Answers  


ORA-07418: sfareq: Database writer got error in timing function.

1 Answers  






ORA-25004: WHEN clause is not allowed in INSTEAD OF triggers

1 Answers  


ORA-09870: spini: failure initializing maximum number of open files.

1 Answers  


NID-00308: Control File string - dbid changed

1 Answers  


DRG-50924: PL/SQL inside PL/SQL not supported

1 Answers  


ORA-01677: standby file name convert parameters differ from other instance

1 Answers  


PLS-00627: 'string' must be a strongly typed ref cursor

1 Answers  


ORA-25145: allocation policy already specified

1 Answers  


Categories