ORA-4031与shared pool综合整理

第一次遇到这个据说是经典错误之一——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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23650854/viewspace-688217/