Memory Notification: Library Cache Object loaded into SGA Heap size 2098K exceeds notification thres

Memory Notification: Library Cache Object loaded into SGA
Heap size 2098K exceeds notification threshold (2048K)

出現原因:
These are warning messages that should not cause the program responsible for these errors to fail. They appear as a result of new event messaging mechanism and memory manager in 10g Release 2.
這都是警告資訊不會因為這些錯誤資訊造成應用程式執行失敗.在oracle10gr2中是由於新的事件訊息機制和記憶體管理才出現的.
The meaning is that the process is just spending a lot of time in finding free memory extents during an allocate as the memory may be heavily fragmented. Fragmentation in memory is impossible to eliminate completely, however, continued messages of large allocations in memory indicate there are tuning opportunities on the application.
這個訊息意味著程式在記憶體呆能存在大量碎片的情況下在執行記憶體分配時花了很長的時間來尋找可用的記憶體空間.記憶體中的碎片不可能完全消除,然而在進行記憶體分配時持續出現這種訊息說明可能是時候對應用程式進行最佳化了.
The messages do not imply that an ORA-4031 is about to happen.
這個訊息並不意味著ora-4031錯誤會立刻出現.

解決方法:
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.
在oracle10g中有一個新的隱含引數來設定KGL堆大小警告閾值.這個引數在10gr1中沒有.當堆大小超過閾值時就會寫入警告資訊.
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.
將_kgl_large_heap_warning_threshold設定為一個合理的較高的值或為0可以阻止這些警告資訊.它的大小單位是byte.

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

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.
注意:在10.2.0.1中這個預設的閾值是2M.因此在有些程式環境中這些警告資訊經常出現.
In 10.2.0.2, the threshold was increased to 50MB after regression tests, so this should be a reasonable and recommended value.
在10.2.0.2中,這個預設的閾值增加到50M.

[@more@]