Resolving/Suppressing Memory Notification: Library Cache Object loaded into SGA

I noticed this entry in alert log of the DB 10.2.0.1 and it generally occurs when your heap size exceeds the allocated memory.

1) Generated by mman(memory manager) process for changing the shared pool size or tuning the shared pool size

Sun Jul 13 18:33:00 2008
Memory Notification: Library Cache Object loaded into SGA
Heap size 6062K exceeds notification threshold (2048K)
KGL object name :SYS.ALERT_QUE

Suppressing the above entry can be done by creating an entry in init.ora file and boucing the instance resolves this issue.

Entry to be done in init.ora
_kgl_large_heap_warning_threshold=8388608 (this value was decided according to instance SGA Size)

Since this is kernel parameter so it need a bounce as it cannot be modified while the instance is running

SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608;
alter system set "_kgl_large_heap_warning_threshold"=8388608
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified