Memory Notification: Library Cache Object loaded into SGA

Hi,

I was getting "Memory Notification: Library Cache Object loaded into SGA". If you search the web or metalink account then can find healty knowledge.

If you are using spfile then
alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile ;

If you are using pifle then just add this parameter.
_kgl_large_heap_warning_threshold=8388608

shutdown immediate;

startup from this new pifle.


Cheers