17,377
社区成员
发帖
与我相关
我的任务
分享这是什么ＯＲＡＣＬＥ错误
ora-04031:无法分配4096字节的共享内存("share pool","begin:1 :=dbms_lob.getchun...","PL/SQLMPCODE","BAMIMA:Bam Buffer")
...全文
请发表友善的回复…
发表回复
jiezhi 2003-04-04
- 打赏
- 举报
设置：
db_block_buffers＝4096*2
db_block_buffers＝4096*2
qiuyang_wang 2003-04-04
- 打赏
- 举报
up
nashan 2003-04-04
- 打赏
- 举报
answer : to use the large pool
nashan 2003-04-04
- 打赏
- 举报
Large Pool
Some DBAs consider the large pool an optional feature for use only when you run a multithreaded server. But I have seen ORA-04031 and ORA-01037 errors that seemed to indicate insufficient shared-pool size when there were, in fact, megabytes of free pool. The errors went away when the large pool was used.
Some DBAs consider the large pool an optional feature for use only when you run a multithreaded server. But I have seen ORA-04031 and ORA-01037 errors that seemed to indicate insufficient shared-pool size when there were, in fact, megabytes of free pool. The errors went away when the large pool was used.
shuipipi 2003-04-04
- 打赏
- 举报
*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
INIT.ORA parameters "shared_pool_reserved_size" and
"shared_pool_size".
If the large pool is out of memory, increase the INIT.ORA
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
INIT.ORA parameters "shared_pool_reserved_size" and
"shared_pool_size".
If the large pool is out of memory, increase the INIT.ORA
wilson 2003-04-04
- 打赏
- 举报
修改你的init.ora文件，增大db_block_buffers和shared_pool_size
