HELP!数据库报错! ORA-04031 错误,我该怎么做?

[haichuang]

ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","unknown object","sga heap","state objects")

我的数据库在运行几天以后就会出这个错误,拿不到连接,执行不了SQL语句,该怎么改正它!

[bzszp]

你的sga区是不是太小了
增加shared_pool_size大小

[bzszp]

你的sga区是不是太小了
增加shared_pool_size大小

[haichuang]

已经很大了!

我听有人说必需使用变量绑定才行,不然每执行一条语句他都会认为是新语句而重新缓冲,是这样的吗?

[kmlinda]

看一看oracle的帮助：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.

[penitent]

我觉得不是绑定的缘故，不过，你是可以先绑定的
我觉得还是shared_pool_size或与此相关的参数分配的不对，把你的init.ora文件拿出来看看