ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded]

Error :

ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded],
Heap size 518675K exceeds notification threshold (51200K)
DDE: Problem Key ‘ORA 600 [KGL-heap-size-exceeded]’ was completely flood controlled (0x6)

We got recently a flood of message in the alert log as above and it was generating a lot of traces and choked our diagnostic_dest destination. We checked the trc files and were seeing like below message

Memory Notification: Library Cache Object loaded into SGA

After Googling around for a while i stumbled onto this blog entry with uncannily similar issues like what we were encountering

http://oraclequirks.blogspot.qa/2009/04/heap-size-nnnnnk-exceeds-notification.html

The suggested workaround as per Oracle Support note,is to increase the threshold level by executing the following statement (on both nodes if RAC)

alter system set “_kgl_large_heap_warning_threshold”=8388608 scope=spfile sid=’*’;

And restart the database giving the error

The errors stopped appearing in the alert log file and the trace file generation also stopped. Apparently setting the hidden parameter to value of 8 MB, so it will monitor only objects with size 8MB and larger

Leave a Reply