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

Memory Notification: Library Cache Object loaded into SGA

Heap size 2183K exceeds notification threshold (2048K)

These are warning messages only which should not cause any problems. 
These warning messages appear due to new event messaging mechanism and memory manager in 10g Release 2. In 10g R2 we have a new undocumented parameter that sets the KGL heap size warning threshold. Warnings are written if heap size exceeds this threshold. 

Default Threshold in 10.2.0.1 is 2 MB only. But Default Threshold value in 10.2.0.2 is 50 MB which is reasonable and recommended value. 

Solution: 


Set _kgl_large_heap_warning_threshold to a reasonable high value to prevent these warning messages.

SQL> alter system set "_kgl_large_heap_warning_threshold"= 52428800 scope=spfile;

SQL> shutdown immediate; 

SQL> startup;