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.
解决方案 »
- 哪位兄弟有OracleXE 10.2 linux 64 bit的安装程序?
- 如何汉化oracle.10g?
- 国内著名电子商务网站诚聘DBA,大家速度报名啦
- Oracle中是否有类似如SQL Server的SQLDMO的ActiveX控件?
- 使用SQL实现循环,在线等~~
- 高分求SQL,请SQL高手帮忙
- sql 关联查询
- 100分请教一下在oracle里有想sql-server里的dateadd这样的函数吗???
- 又是一个imp的问题。
- 新手请教sqlplus与oracle基础问题
- 谁用过oracle的oo4o code wizard?--救命啊
- 可不可以用function或是procedure返回多条记录?
ORA-04031 unable to allocate string bytes of shared memory ("string","string","string","string") 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