内存不够了,怎么发生的?
可以的话,增大SHARED_POOL_RESERVED_SIZE and SHARED_ POOL_SIZE
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.
可以的话,增大SHARED_POOL_RESERVED_SIZE and SHARED_ POOL_SIZE
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.
解决方案 »
- 海量 数据 数据库 选择
- 如何将一个表中的部分记录赋值到另一个表中?
- 关于oracle administration assistant添加操作系统数据库管理员用户?
- ORACLE触发器问题
- 我快崩溃了,大家来帮帮忙吧
- 拜托各位帮忙看下 总是搞乱各种条件 最后一团糟 大神帮忙写下啊
- 高分求一个视图
- Oracle8.1.7在win2k pro英文版下不能安装(在线等待...)
- 初学者问题,怎样进入oracle managerment server(oms)?
- oracle 查询语句
- 请问:oracle中怎么查询上次插入数据后该表中加入数据的行数?谢谢
- ORACLE816如何在过程中创建临时表?急,在线等待
是不是SCO unix系统?