ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-4031与shared pool综合整理

ORA-4031与shared pool综合整理

原创 Linux操作系统 作者:zecaro 时间:2011-03-01 22:11:54 0 删除 编辑

第一次遇到这个据说是经典错误之一——ORA-04031。mark~

$ oerr ora 4031
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.
// *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".

      先是在rman的日志里发现如下错误的。

ORA-04031: unable to allocate 41456 bytes of shared memory ("shared pool","DBMS_RCVMAN","PL/SQL MPCODE","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_RCVMAN"

一、相关参数

SHARED_POOL_SIZE

SHARED_POOL_RESERVED_SIZE

SHARED_POOL_RESERVED_MIN_ALLOC

desc x$ksmsp

 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------------------------------
 ADDR                                                           RAW(8)
 INDX                                                           NUMBER
 INST_ID                                                        NUMBER
 KSMCHIDX                                                       NUMBER
 KSMCHDUR                                                       NUMBER
 KSMCHCOM                                                       VARCHAR2(16)
 KSMCHPTR                                                       RAW(8)
 KSMCHSIZ                                                       NUMBER
 KSMCHCLS                                                       VARCHAR2(8)
 KSMCHTYP                                                       NUMBER
 KSMCHPAR                                                       RAW(8)

 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23650854/viewspace-688217/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-10-28

  • 博文量
    182
  • 访问量
    348635