Memory Notification: Library Cache Object loaded into SGA
Heap size 8819K exceeds notification threshold (2048K)

Hello viewers:

Today Morning i have found that the  message on alertlog of oracle 10g r2 version 10.2.0.1. To  avoid these messages being generated, we need to adjust the size of a hidden initialization parameter. The hidden  initialization parameter is “_kgl_large_heap_warning_threshold”. We can avoid this message to set a high value or zero.

 Note:- Set  "_kgl_large_heap_warning_threshold" to a reasonable high value or zero to prevent these warning messages. Value needs to be set in bytes. The default threshold in 10.2.0.1 is 2MB. So these messages could show up frequently in some application environments. In 10.2.0.2, the threshold was increased to 50MB after regression tests, so this should be a reasonable and recommended value.

To modify this parameter:

login as sysdba

SQL> connect sys as sysdba
SQL> alter system set "_kgl_large_heap_warning_threshold"=52428800 scope=spfile ;
System altered.


SQL> shutdown immediate;
SQL> startup;


Now the following message will not come.