ORA-23603: STREAMS enqueue aborted due to low SGA

 

ORA-23603: STREAMS enqueue aborted due to low SGA

[oracle@CNC-BJ-F-5D3 ~]$ oerr ora 23603
23603, 00000, "STREAMS enqueue aborted due to low SGA"
// *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.

 

增大参数streams_pool_size （已经设置该参数大于0的情况下）或增大shared_pool_size

 

 sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Jul 18 15:26:41 2008

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> show parameter streams_pool_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size                    big integer 208M

SQL> show parameter shared_pool

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
shared_pool_reserved_size            big integer 90596966
shared_pool_size                     big integer 1264M
SQL>

由于是第一次出现该错误，随后也没有再报错，策略是先继续观察一段时间，然后再做抉择，必定是线上系统不能轻易修改内存参数，虽然Oracle可以做动态调整，但这不代表没有风险。

不恰当的时机修改可能会导致数据库宕掉。很遗憾我曾经遇到过。