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

LU人的博客nkrdi

%Cp5g%?,A|1bfU|T5c0呵呵，Note:330239.1。

SDFXfL%C^s;u0LU人的博客/HQb+bD!J

解决问题三步曲：

h3](KV?%@0SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile ;LU人的博客
BBaqKC
LU人的博客�QH%M1`ZY�nL9MR+l
SQL> shutdown immediate

tW*b.q I*P0LU人的博客z2u-KZ$fL"@;b4I

SQL> startup

6}}Fi^M8O,W0

LU人的博客4L0l5NWz1knn,q&JLU人的博客#cw#X$\?NE1[F

Oracle对此的解释是：LU人的博客fK.m&psf5vY D"?3BY;U

[[4^Uwg:C@'h0NOTE:  The default threshold in 10.2.0.1 is 2M.   So these messages could show up frequently in some application environments.

)LPGqp"f0LU人的博客H(|G8cKC|t

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.