Oracle数据库,服务启动时,报告这个错,何解啊?帮帮小妹啊。。。

streamlong 发布于 2013/08/29 19:00
阅读 211
收藏 0
Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 8148 bytes of shared memory ("large pool","PROCEDURE$","kxs-heap-w","qesaQBInit:buffer")
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 12344 bytes of shared memory ("large pool","unknown object","session heap","kxsFrame4kPage")
ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 8148 bytes of shared memory ("large pool","unknown object","kxs-heap-w","qesaQBInit:buffer")

经查找,得到的其中一个结果是:large_pool_size = 0,根据帖子上说,需要把它修改成512M,可是在修改过程中,得到的结果是:内存不够,无法修改

加载中
0
王瑞平
王瑞平
先要修改target_memory的值
streamlong
streamlong
请问,你能详细描述下吗?我不怎么明白....谢谢
0
王瑞平
王瑞平

生成数据库时候都会让你分配内存,估计你这个是分小了

没有空间留给大池了,你仔细看下ORACLE文档SGA设置吧

返回顶部
顶部