Friday, August 21, 2009

ORA-00600: internal error code, arguments: [729], [], [space leak]

Refer to error captured from udump.

Unix process pid: 18832, image: oracle@xxxxxx (TNS V1-V3)

*** 2009-08-20 20:11:02.518
*** SESSION ID:(33.19527) 2009-08-20 20:11:02.516
******** ERROR: UGA memory leak detected 9536 ********
******************************************************
HEAP DUMP heap name="session heap" desc=0x1a6e908
extent sz=0x108c alt=32767 het=32767 rec=0 flg=3 opc=3
parent=1a14c28 owner=900ac708 nex=0 xsz=0x2050
EXTENT 0
Chunk 1aa2e84 sz= 4228 free " "
EXTENT 1
Chunk 1a8493c sz= 888 free " "
Chunk 1a84cb4 sz= 740 freeable "define var info"
EXTENT 2
Chunk 1ab9094 sz= 536 free " "
Chunk 1ab92ac sz= 376 freeable "define var info"
Chunk 1ab9424 sz= 184 free " "
Chunk 1ab94dc sz= 740 freeable "define var info"
Chunk 1ab97c0 sz= 536 free " "
Chunk 1ab99d8 sz= 376 freeable "define var info"
Chunk 1ab9b50 sz= 740 freeable "define var info"
.
.
.
.
.
*** 2009-08-20 20:11:02.521
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [729], [9536], [space leak], [], [], [], [], []

A space leak has been detected in the User Global Area (UGA). There is no data corruption as a result of this error. It is an internal memory housekeeping problem. The second argument,9536 is the number of bytes leaked.

The above dump show Memory leak. Oracle is trying to free memory allocated to a process. Chunk 1a84cb4,1ab92ac and the rest with freeable "define var info" show memory leaked.

This can be safely ignore for small memory leaks by adding the following event to init.ora:
event = "10262 trace name context forever, level 10240"
Then, restart your database. This event disables space leaks less than 10 kbytes.

You can see the details at Metalink Doc ID: 31056.1 ORA-600 [729] "UGA Space Leak" and Doc ID: 403584.1 Understanding and Diagnosing ORA-600 [729] Space Leak Errors

Bug:
Bug:2177050: ORA-600 [729] after application of the 8.1.7.3 patchset. The resulting trace file will include a memory dump which shows unfreed memory chunks with the tags "define var info" and/or "oactoid info".