问题

Thu Jan 14 23:34:38 2010

Memory Notification: Library Cache Object loaded into SGA

Heap size 2358K exceeds notification threshold (2048K)

Details in trace file d:\oracle\product\10.2.0\admin\db3\udump\db3_ora_2312.trc

KGL object name :XDB.XDZynXpO5DTv2jNMI2jLTZZA==

问题类型：

oracle 10.2.0.1 BUG, 在10.2.0.2中被fixed，不影响使用

是否要重启：

重启数据库

解决办法：

(logged in as "/ as sysdba")

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

SQL> shutdown immediate

SQL> startup

SQL> show parameter _kgl_large_heap_warning_threshold

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

_kgl_large_heap_warning_threshold integer 8388608

If using an "old-style" init parameter,

Edit the init parameter file and add

_kgl_large_heap_warning_threshold=8388608

问题原因：

Memory Notification: Library Cache Object Loaded Into Sga

In 10g we have a new undocumented parameter that sets the KGL heap size warning threshold. This parameter was not present in 10gR1.Warnings are written if heap size exceeds this threshold.
 
Set _kgl_large_heap_warning_threshold to a reasonable high value or zero to prevent these warning messages. Value needs to be set in bytes.

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, please contact Oracle Support Services for further investigation of any possible shared pool problems.