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@]