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
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.
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
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.
解决方案 »
- 请教高手 创建性能最优的ORACLE库实例
- oracle的clob类型的字段,存储的文本内容,怎样转换为字符创并去掉换行符?
- 关于OCI的数据提取和输出(请路过的指点一下)
- oracle双机热备怎么装?急!!
- 重装WINDOWS200后ORACLE的处理办法
- asp连接oracle报错:“监听进程不能解析在连接描述符中给出的 SERVICE_NAME ”……
- 请问为什么会出错
- oracle中必须用to_date函数才能够把日期型的值保存进数据库吗?
- 关于view的困惑
- ORA-01041: internal error. hostdef extension doesn't exist
- 如何写一个判断是否在数据库中已经有此记录的存储过程?
- 招聘经验丰富Oracle兼职教师!北京 农科院附近 100元/月 起 mail:[email protected]
发这条语句刷新下,
ALTER SYSTEM FLUSH shared_POOL;
或者重新配制INIT。ORA参数加大参数的值重新启动数据库。