ORA-04031: unable to allocate 4096 bytes of shared memory

ORA-00604: error occurred at recursive SQL level 3
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
pool","select /*+ rule */ bucket_cn...","Typecheck heap","kgghteInit")
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
pool","select /*+ rule */ bucket_cn...","Typecheck heap","kgghteInit")

 

项目在开发阶段未出现此问题, 发布后Exception 出来了.

 

解决方法:

1,找到 oracle 数据库 目录,修改配置文件,我的目录是 F:\oracle\product\10.1.0\admin\rck\pfile

        init.ora.519200919534

修改 init.ora.519200919534 的最大共享连接数

...........................................略

# Pools
###########################################
java_pool_size=50331648
large_pool_size=8388608
shared_pool_size=83886080

###########################################

...........................................略

把 shared_pool_size=83886080 改为 shared_pool_size=93886080

 

 

2,重新装载此配置文件.以 System 帐号登陆,

运行sql语句.

SQL>startup force pfile=F:\oracle\product\10.1.0\admin\rck\pfile\init.ora.519200919534' ;

 

即可.