Memory Notification: Library Cache Object Loaded Into Sga

Problem :

Found many notifications in the alert.log reporting that a threshold was exceeded on the heap size.

Solution :

Set the hidden parameter _kgl_large_heap_warning_threshold to a reasonable greater size. The default threshold in 10.2.0.1 is 2M. In 10.2.0.2, the threshold was increased to 50M. See Metalink Note

330239.1