Nov 18 2009

ORA-00600 [723],[10424],[10424] Memory Leak

PURPOSE:
This article discusses the internal error “ORA-600 [723]“, what
it means and possible actions. The information here is only applicable
to the versions listed and is provided only for guidance.

ERROR:
ORA-600 [723] [a] [b]

VERSIONS:
versions 6.0 to 10.1

DESCRIPTION:
This is a memory leak in the Program Global Area (PGA)

PGA is checked for Space leaks at logoff time and a leak was found.

There is no data corruption with this error.

ARGUMENTS:
Arg [a] Logoff PGA size in bytes
Arg [b] “memory leak”

FUNCTIONALITY:
MEMORY COMPONENT

IMPACT:
PROCESS FAILURE – but only during session delete so impact is minimal
NON CORRUPTIVE – No underlying data corruption.

SUGGESTIONS:
Event 10262 can be set to safely ignore small memory leaks.

Set the following in init.ora for example to disable space
leaks less than 4000 bytes:

event = “10262 trace name context forever, level 4000″

and stop and restart the database

Comments are closed.

Alibi3col theme by Themocracy