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

轉：

        給一個客戶，處理了壞塊問題後，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.