这篇博客讨论了Oracle 10g数据库在加载Library Cache Object到SGA时遇到内存警告的问题。警告显示堆大小超过2048K的阈值。这个问题在10.2.0.1版本中较为常见，但已在10.2.0.2版本中得到改善。解决方案是调整隐藏参数_kgl_large_heap_warning_threshold的值，以减少或消除这些警告。
1.环境
--系统环境
[oracle@ias oracle]$ more /etc/redhat-release
Red Hat Enterprise Linux AS release 3 (Taroon Update 5)
--数据库版本
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 – Production
2.alert日志信息
Tue Oct 15 14:24:00 2013
Memory Notification: Library Cache Object loaded into SGA
Heap size 2122K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==
Tue Oct 15 14:24:00 2013
Memory Notification: Library Cache Object loaded into SGA
Heap size 2371K exceeds notification threshold (2048K)
Details in trace file /ias/iasdb/admin/orcl/udump/orcl_ora_4370.trc
KGL object name :XDB.XD+s5hmkr05krgMFeMBRYQnQ==
Tue Oct 15 22:00:09 2013
Thread 1 advanced to log sequence 5646
Current log# 2 seq# 5646 mem# 0: /ias/iasdb/oradata/orcl/redo02.log
Current log# 2 seq# 5646 mem# 1: /ias/iasdb/oradata/orcl/redo02a.log
3.orcl_ora_4370.trc文件信息
/ias/iasdb/admin/orcl/udump/orcl_ora_4370.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /ias/iasdb/
System name: Linux
Node name: XXXXXXXXX
Release: 2.4.21-32.ELsmp
Version: #1 SMP Fri Apr 15 21:17:59 EDT 2005
Machine: i686
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 65
Unix process pid: 4370, image: oracleorcl@XXXXXXXX
*** SERVICE NAME:(orcl) 2013-10-15 14:24:00.098
*** SESSION ID:(102.588) 2013-10-15 14:24:00.098
Memory Notification: Library Cache Object loaded into SGA
最低0.47元/天 解锁文章
扫一扫
6900
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
