报错：ORA-00604,ORA-04031

czy5025

试验环境 数据库版本10.2.0.1.0，操作系统版本RHEL4U6
sys@ORCL> desc dictionary;
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 16 bytes of shared memory ("shared pool","select
obj#,type#,ctime,mtim...","sql area","kglhin: temp")

查了一下资料如下：
ORA-04031 unable to allocate string bytes of shared memory ("string","string","string","string")

Cause:
More shared memory is needed than was allocated in the shared pool.

Action:
If the shared pool is out of memory, either use the DBMS_SHARED_ POOL package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_ POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE.

sys@ORCL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost ~]$ sqlplus / as sysdba;

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 29 11:25:47 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected.
ERROR:
ORA-01012: not logged on

问题：当我exit后，就无法再登陆了，只能重启系统改shared pool 大小，真实环境也只能重启吗？（新手，请前辈们赐教）

bbc1216

没有采用自动SGA管理？自动SGA管理应该可以动态扩展share pool的大小

czy5025

我知道可以设置sga_target，只是自己在练习阶段，把share_pool手动改了下。

山野村夫

呵呵，好像是只能重启修改，所以在10g开始提供自动的功能了

[ 本帖最后由 山野村夫 于 2009-4-14 11:27 编辑 ]

czy5025

我明白了。谢谢。