[转]10.2.0.1的小bug：Memory NotificationLibrary Cache Object Loaded Into Sga

转：http://www.loveunix.cn/html/32/1132-14563.html

        给一个客户，处理了坏块问题后，alert又开始迅速增加了，原来里面多许多这样的内容
       我刚才查看日志，发现总是出现notification Memory Notification: Library Cache Object loaded into SGA Heap size 21019K exceeds notification threshold (2048K) KGL object name :SYS.ALERT_QUE
        呵呵，Note:330239.1。
        解决问题三步曲：
SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile ;
SQL> shutdown immediate
SQL> startup
       Oracle对此的解释是
NOTE:  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.

 

转载于:http://blog.itpub.net/22275400/viewspace-714735/