Memory Notification: Library Cache Object loaded into SGA

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