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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s