Memory Notification: Library Cache Object loaded into SGA
My Oracle is 10.2.0.1 (64 bit)
OS: Linux 64 bit.
SGA_MAX_SIZE = SGA_TARGET = 8G
My alert.log has some notifications such as:
==========================
Sat Jun 4 04:11:19 2011
Thread 1 advanced to log sequence 58924
Current log# 1 seq# 58924 mem# 0: /u01/app/oracle/oradata/vtadb/redo01.log
Sat Jun 4 06:03:14 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 2474K exceeds notification threshold (2048K)
KGL object name :select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*),count("ETY_ID"),count(distinct "ETY_ID"),sum(sys_op_opnsize("ETY_ID")),substrb(dump(min("ETY_ID"),16,0,32),1,120),substrb(dump(max("ETY_ID"),16,0,32),1,120),count("RENT_UOM"),count(distinct "RENT_UOM"),sum(sys_op_opnsize("RENT_UOM")),substrb(dump(min(substrb("RENT_UOM",1,32)),16,0,32),1,120),substrb(dump(max(substrb("RENT_UOM",1,32)),16,0,32),1,120),count("RENT_UNIT