Memory Notification: Library Cache Object loaded into SGA 告警
放假回來,查alert告警日誌,發現如下警告:
Sat Apr 30 02:20:14 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 3800K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==
Sat Apr 30 02:20:17 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 4092K exceeds notification threshold (2048K)
Details in trace file /oracle/admin/orcl/udump/orcl1_ora_11059.trc
KGL object name :XDB.XD+7TrZzhrF9fgNAADukSwiw==
經google發現是ORACLE的一個微小的BUG(10.2.0.1),在後續的版本中已經改進。如果要在該版本中將告警抑制住可以進行如下操作:
SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile ;
SQL> startup force
SQL> show parameters_kgl_large_heap_warning_threshold
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_kgl_large_heap_warning_threshold integer 8388608
In 10.2.0.2, 這個閥值已經能夠增到 50MB
SQL> startup force
SQL> show parameters_kgl_large_heap_warning_threshold
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_kgl_large_heap_warning_threshold integer 8388608
In 10.2.0.2, 這個閥值已經能夠增到 50MB
ORACLE官方的解釋:
Applies to: Oracle Server - Enterprise Edition - Version:
This problem can occur on any platform.
. SymptomsThe 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)
ChangesInstalled / Upgraded to 10g Release 2
CauseThese 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-403X is about to happen.
SolutionIn 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.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/14184018/viewspace-694287/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Memory Notification: Library Cache Object loaded into SGAObject
- 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 [ID 330239.1]Object
- 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理解
- 基於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
- zt_如何使用event 10049分析定位library cache lock and library cache pin
- latch:library cache lock等待事件事件
- oracle異常:library cache lockOracle
- 深入理解shared pool共享池之library cache的library cache lock系列四