Memory Notification: Library Cache Object Loaded Into Sga [ID 330239.1]
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later [Release: and later ]Information in this document applies to any platform.
Oracle Server Enterprise Edition
.
Symptoms
The following messages are reported in alert.log after 10g Release 2 is installed.
Memory Notification: Library Cache Object loaded into SGA
Heap size 2294K exceeds notification threshold (2048K)
Changes
Installed / Upgraded to 10g Release 2
Cause
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.
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.
Solution
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
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.來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15747463/viewspace-735587/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Memory Notification: Library Cache Object loaded into SGAObject
- Memory Notification: Library Cache Object loaded into SGA 告警Object
- Memory Notification: Library Cache Object loaded into SGA問題Object
- 【問題處理】Memory Notification: Library Cache Object loaded into SGAObject
- Memory Notification: Library Cache Object loaded into SGA Heap size 2098K exceeds notification thresObject
- oracle 10.2.0.1的小bug:Memory NotificationLibrary Cache Object Loaded Into SgaOracleObject
- [轉]10.2.0.1的小bug:Memory NotificationLibrary Cache Object Loaded Into SgaObject
- Library Cache Object loaded into SGA Heap size 2226K exceeds notification threshold (2048K)Object
- Flush an Object Out The Library Cache [SGA] Using The DBMS_SHARED_POOLObject
- shared pool之三:library cache結構/library cache object的結構-dump LibraryHandleObject
- library cache內容系列一之library hash bucket--library object handle--heapObject
- Library Cache Pin 及 Library Cache Lock分析
- library cache lock和library cache pin理解
- 【構建Android快取模組】(二)Memory Cache & File CacheAndroid快取
- 基於row cache object latch研究對於sga抖動的影響Object
- Oracle RDBMS : Flushing a Single SQL Statement out of the Object Library CacheOracleSQLObject
- oracle library cache之library cache lock_library cache pin wait event釋義OracleAI
- 關於memory_max_target,memory_target,sga_max_size,sga_target
- Oracle Library cacheOracle
- Linux Cache MemoryLinux
- library cache pin和library cache lock的診斷分析
- library cache lock和library cache pin區別總結
- SGA PGA MEMORY_TARGET 關係
- 定位Library Cache pin,Library Cache lock等待的解決方法
- zt_如何平面解決library cache lock和library cache pin
- dyld: Library not loaded: @rpath/Alamofire.framework/AlamofireFramework
- 【等待事件】library cache pin事件
- 等待事件--library cache pin事件
- library cache pin等待分析
- LIBRARY CACHE LOCK 等待事件事件
- library cache pin 等待事件事件
- 解決Library Cache latchs
- 【ASK_ORACLE】Library Cache概念篇(二)之Library Cache Pin的定義Oracle
- ceph-immmutable-object-cacheObject
- v$db_object_cacheObject
- Android 《Notification》Android
- zt_如何使用event 10049分析定位library cache lock and library cache pin
- latch:library cache lock等待事件事件