10.2.0.1的小bug：Memory NotificationLibrary Cache Object Loaded Into Sga
alert文件中出现如下错误
Memory Notification: Library Cache Object loaded into SGA
Heap size 3592K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==
Wed Aug 18 13:34:15 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 3819K exceeds notification threshold (2048K)
Details in trace file /u01/oracle/admin/think/udump/think_ora_31726.trc
KGL object name :XDB.XDA8XlWX/h+P3gQFeMmGQWfg==
解决问题三步曲：
|
SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile ; SQL> startup |
Oracle对此的解释是：
The default threshold in 10.2.0.1 is 2M. 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. If you continue to see the these warning messages in the alert log after applying 10.2.0.2 or higher, an SR may be in order to investigate if you are encountering a bug in the Shared Pool.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16566331/viewspace-671309/ ，如需转载，请注明出处，否则将追究法律责任。
