Memory Notification: Library Cache Object loaded into SGA

<!-- /* Font Definitions */ @font-face{font-family:宋体;panose-1:2 1 6 0 3 1 1 1 1 1;mso-font-alt:SimSun;mso-font-charset:134;mso-generic-font-family:auto;mso-font-pitch:variable;mso-font-signature:3 135135232 16 0 262145 0;}@font-face{font-family:"/@宋体";panose-1:2 1 6 0 3 1 1 1 1 1;mso-font-charset:134;mso-generic-font-family:auto;mso-font-pitch:variable;mso-font-signature:3 135135232 16 0 262145 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal{mso-style-parent:"";margin:0cm;margin-bottom:.0001pt;text-align:justify;text-justify:inter-ideograph;mso-pagination:none;font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:宋体;mso-font-kerning:1.0pt;}p{mso-margin-top-alt:auto;margin-right:0cm;mso-margin-bottom-alt:auto;margin-left:0cm;mso-pagination:widow-orphan;font-size:12.0pt;font-family:宋体;mso-bidi-font-family:宋体;}span.javascript{mso-style-name:"javascript/.";} /* Page Definitions */ @page{mso-page-border-surround-header:no;mso-page-border-surround-footer:no;}@page Section1{size:612.0pt 792.0pt;margin:72.0pt 90.0pt 72.0pt 90.0pt;mso-header-margin:36.0pt;mso-footer-margin:36.0pt;mso-paper-source:0;}div.Section1{page:Section1;}-->

在alter.log中报

Memory Notification: Library Cache Object loaded into SGA
Heap size 2131K exceeds notification threshold (2048K)
Details in trace file e:/oracle/product/10.2.0/admin/service/udump/service_ora_4372.trc
KGL object name :XDB.XDZynXpO5DTv2jNMI2jLTZZA==

......

 

处理办法：

 

Oracle10.2.0.1这个参数设置过小,系统会自动扩展，没有性能问题

SQL>alter system set"_kgl_large_heap_warning_threshold" =8388608 scope=spfile;

 

迁移到Oracle10.2.0.2就没有这个问题了