Monday 10 March 2014

PGA Memory Leak - ORA-00600: internal error code, arguments: [723], [120248], [245704], [memory leak]

PGA Memory Leak - ORA-00600: internal error code, arguments: [723], [120248], [245704], [memory leak]


ORA-00600: internal error code, arguments: [723], [120248], [245704], [memory leak], [], [], [], [], [], [], [], []

========= Dump for incident 103210 (ORA 600 [723]) ========
----- Beginning of Customized Incident Dump(s) -----
******** ERROR: PGA memory leak detected 245704 > 120248 ********
******************************************************
HEAP DUMP heap name="pga heap"  desc=0xb7e8bc0
 extent sz=0x20c0 alt=216 het=32767 rec=0 flg=3 opc=3
 parent=(nil) owner=(nil) nex=(nil) xsz=0xfff0 heap=(nil)
 fl2=0x60, nex=(nil), dsxvers=1, dsxflg=0x0
 dsx first ext=0x80642720
EXTENT 0 addr=0x2b2f807fd010
  Chunk     2b2f807fd020 sz=    25984    perm      "perm           "  alo=4424
  Chunk     2b2f808035a0 sz=    10680    free      "               "
  Chunk     2b2f80805f58 sz=      128    freeable  "kzam_osx_cleanu"
  ...............
  
  ----- Call Stack Trace -----
  kgdsdstsg <- dbgc_dmp <- dbgexPhaseII <- dbgexExplicitEndInc <- dbgeEndDDEInvocatio  
  <- nImpl <- dbgeEndDDEInvocatio <- ksmdpg <- opidcl <- opidrv  
  <- sou2o <- opimai_real <- ssthrdmain <- main <- libc_start_main   
  <- start


Setting EVENT 10262:

When having a such error (ORA-600 [723]) set the event 10262. 

Set the following to ignore the error for small leaks (less than 500000 bytes):

ALTER SYSTEM SET EVENT='10262 trace name context forever, level 500000' SCOPE=SPFILE;

The instance must be restarted for the events to take effect.

No comments:

Post a Comment