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-28151: more than one user name specified for command

1 Answers  


ORA-12015: cannot create a fast refresh materialized view from a complex query

1 Answers  


ORA-32019: The parameter SPFILE cannot be updated in the server parameter file.

1 Answers  


ORA-03217: invalid option for alter of TEMPORARY TABLESPACE

1 Answers  


ORA-39149: cannot link privileged user to non-privileged user

1 Answers  






PLS-01703: Cursor name in CLOSE statment must be of length 1

1 Answers  


IMG-02008: 2FF08 - color histogram feature cannot be determined

1 Answers  


ORA-29273: HTTP request failed

1 Answers  


RMAN-06549: connected to auxiliary database: string (not mounted)

1 Answers  


PLS-00130: Pragma string expects 1st argument to be a procedure/function/package/cursor

1 Answers  


IMP-00099: Warning: The typeid in the dump file for object type "string"."string" is invalid

1 Answers  


ORA-09767: osnmfs: bad return code from msg_send.

1 Answers  


Categories