用户的oracle的alert日志里发现个问题，大家帮忙看看

[zjwssg]

Thu Feb 4 18:05:24 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 2238K exceeds notification threshold (2048K)
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM FROM SYS.KU$_HTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY,8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS,128)!=0 AND KU$.SCHEMA_OBJ.NAME=:NAME1 AND KU$.SCHEMA_OBJ.OWNER_NAME=:SCHEMA2
Thu Feb 4 22:00:11 2010

此错误在日志中不定时出现，有时一天几次，有时半个月一次。有见过的吗？

[suiziguo]

take a look at this metalink note...

Subject: Memory Notification: Library Cache Object Loaded Into Sga
Doc ID: 330239.1

here is the solution out of the above doc...

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.

If you want to set this to 8192 (8192 * 1024) and are using an spfile:

(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


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.


你是10.2.0.1？手动把该阀值增大。

其实不增大也没关系，只是警告看起来烦。

[zjwssg]

嗯，我自己也查到了相同的文档，呵呵。看起来没头脑，不过还好有资料。