ORACLE_OCP之oerr命令查看报错

ORACLE_OCP之oerr命令查看报错

  • oerr ORA 04031
  • 栗子:

    [oracle@oracle12 dbs]$ oerr ORA 04031
    04031, 00000, “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 or Streams 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.
    // If the error is issued from an Oracle Streams or XStream process,
    // increase the initialization parameter STREAMS_POOL_SIZE or increase
    // the capture or apply parameter MAX_SGA_SIZE.
    [oracle@oracle12 dbs]$

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值