oracle 10.2.0.1的小bug：Memory NotificationLibrary Cache Object Loaded Into Sga
os：aix 6
db：oracle10.2.0.1
早上在用户现场检查oracle的alert日志，发现日志大量出现
notification Memory Notification: Library Cache Object loaded into SGA Heap size 21019K exceeds notification threshold (2048K) KGL object name : xxxxxxxxx
google到一个解决办法：
SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile ;
SQL> shutdown immediate
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.
看来要解决该问题还是升级10.2.0.4比较好
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7417660/viewspace-1033372/ ，如需转载，请注明出处，否则将追究法律责任。
