我也不太清楚,但可能是权限的问题。
还是找找有关资料吧。
ORA-04031: unable to allocate bytes of shared memory ("","","","")
还是找找有关资料吧。
ORA-04031: unable to allocate bytes of shared memory ("","","","")
解决方案 »
- ORA-01109: 数据库未打开
- sqlserver 中大量用到临时表,oracle中怎么破???
- oracle数据空间问题请教
- 连接数据库提示oracle initialization or shutdown in process
- 噢日阿才
- PL/SQL字符串连接问题
- oracle闪回出错!快照过旧 回退段号5的问题
- not exists无效?
- 关联查询语句怎么条件不同执行计划也不同呢?
- 有没有Oracle for Solaris(x86)??
- apache 由1.3.9升级到1.3.12后,oracle application的显示字符怎么不是简体中文,变为乱码了?
- 安装DEVELOPE的问题
SHARED_POOL_RESERVED_SIZE
SHARED_POOL_SIZE
LARGE_POOL_SIZE
04031: "unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s\",\"%s\")"
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
parameter "large_pool_size".
共享池:60M
缓冲区高速缓存:32M
大型池:1024k
Java池:32M
SGA总容量为:93.76959M
我尝试过在oracle的管理界面中修改这几个参数,但提示说:
无法应用动态参数,ora-02097,无法修改参数,因为指定的值无效
ora-00384:没有足够的内存来增加高速缓存的大小
难道只有在数据库的参数文件中配置?
另外,刚开始开发的时候,并没有出现过这个问题,后来好像在写了几个存储(都是比较简单的)之后,才开始出现这个问题的。这和大型池、Java池有关嘛?
谢谢!请一定帮忙!