Weird messages in the alert.log file

From: Peter Teoh <htmldeveloper_at_gmail.com>
Date: Tue, 24 Jun 2008 10:39:23 +0800
Message-ID: <48605E5B.1050706@gmail.com>

First, my alert.log is showing these messages:

Heap size 2789K exceeds notification threshold (2048K) Details in trace file
/u01/app/oracle/product/10.2.0/db_1/rdbms/log/babydb_ora_6254.trc
KGL object name :grant select on PLUGGABLE_SET_CHECK to SELECT_CATALOG_ROLE Mon Jun 23 08:08:47 2008
Memory Notification: Library Cache Object loaded into SGA Heap size 3114K exceeds notification threshold (2048K) Details in trace file
/u01/app/oracle/product/10.2.0/db_1/rdbms/log/babydb_ora_6254.trc

KGL object name :select a.*,   case when      
input_bytes/decode(output_bytes, 0, null, output_bytes) > 1   then      

input_bytes/decode(output_bytes, 0, nul
l, output_bytes) else 1 end compression_ratio, sys.dbms_rcvman.num2displaysize(input_bytes) input_bytes_display, sys.dbms_rcvman.num2displaysize(output
_bytes) output_bytes_display from (select sum(num_files_backed)

num_files_backed,       sum(distinct_files_backed) 
distinct_files_backed,       min(min_firs
t_change#) min_first_change#,       max(max_next_change#)

Mon Jun 23 08:09:40 2008
Thread 1 advanced to log sequence 3
  Current log# 1 seq# 3 mem# 0:
/u01/app/oracle/oradata/BABYDB/onlinelog/o1_mf_1_45xryt3b_.log
Mon Jun 23 08:09:49 2008
Memory Notification: Library Cache Object loaded into SGA Heap size 2093K exceeds notification threshold (2048K) Details in trace file
/u01/app/oracle/product/10.2.0/db_1/rdbms/log/babydb_ora_6254.trc
KGL object name :grant select on ku$_iont_view to select_catalog_role Mon Jun 23 08:09:49 2008
Memory Notification: Library Cache Object loaded into SGA Heap size 2091K exceeds notification threshold (2048K) Details in trace file
/u01/app/oracle/product/10.2.0/db_1/rdbms/log/babydb_ora_6254.trc
KGL object name :grant select on ku$_iont_view to select_catalog_role Mon Jun 23 08:09:50 2008
Memory Notification: Library Cache Object loaded into SGA Heap size 4678K exceeds notification threshold (2048K) Details in trace file
/u01/app/oracle/product/10.2.0/db_1/rdbms/log/babydb_ora_6254.trc
Mon Jun 23 08:09:51 2008
Memory Notification: Library Cache Object loaded into SGA Heap size 5134K exceeds notification threshold (2048K) Details in trace file
/u01/app/oracle/product/10.2.0/db_1/rdbms/log/babydb_ora_6254.trc
KGL object name :grant select on ku$_nt_parent_view to select_catalog_role Mon Jun 23 08:09:51 2008
Memory Notification: Library Cache Object loaded into SGA Heap size 5133K exceeds notification threshold (2048K) Details in trace file
/u01/app/oracle/product/10.2.0/db_1/rdbms/log/babydb_ora_6254.trc
KGL object name :grant select on ku$_nt_parent_view to select_catalog_role Mon Jun 23 08:09:52 2008
Memory Notification: Library Cache Object loaded into SGA Heap size 2250K exceeds notification threshold (2048K) Details in trace file
/u01/app/oracle/product/10.2.0/db_1/rdbms/log/babydb_ora_6254.trc
Mon Jun 23 08:09:52 2008
Memory Notification: Library Cache Object loaded into SGA Heap size 2382K exceeds notification threshold (2048K) Details in trace file
/u01/app/oracle/product/10.2.0/db_1/rdbms/log/babydb_ora_6254.trc
KGL object name :grant select on ku$_htable_view to public Mon Jun 23 08:09:52 2008
Memory Notification: Library Cache Object loaded into SGA Heap size 2382K exceeds notification threshold (2048K) Details in trace file
/u01/app/oracle/product/10.2.0/db_1/rdbms/log/babydb_ora_6254.trc
KGL object name :grant select on ku$_htable_view to public

What are these different comments?

Am I supposed to do anything?

And looking at the trace file generated:

/u01/app/oracle/product/10.2.0/db_1/rdbms/log/babydb_ora_6254.trc - it
is about 10K lines long, extracts are here (if u are interested I can gzip the file for you):

namespace=CRSR flags=RON/KGHP/PN0/[10010000] kkkk-dddd-llll=0000-0001-0000 lock=N pin=X latch#=3 hpc=0002 hlc=0002

lwt=0x229e4414[0x229e4414,0x229e4414] ltm=0x229e441c[0x229e441c,0x229e441c]
pwt=0x229e43f8[0x229e43f8,0x229e43f8] ptm=0x229e4400[0x229e4400,0x229e4400]
ref=0x229e4434[0x22548490,0x22548490] lnd=0x229e4440[0x229e4440,0x229e4440]

  LIBRARY OBJECT: object=22547ff0
  type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0   DEPENDENCIES: count=49 size=64
  dependency# table reference handle position flags

• -------- --------- -------- -------- ------------------- 0 22548360 22b9dec0 22eba44c 16 DEP[01] 1 22548360 22b9df0c 21f615ec 335 DEP[01] 2 22548360 22b9df40 23788df4 44 DEP[01] 3 22548360 22b9df74 2377274c 31 DEP[01] 4 22548360 22b9dfa8 2362d490 288 DEP[01] 5 22548360 22b9dfdc 23548420 540 DEP[01] 6 22548360 22b9e010 22efd664 648 DEP[01] 7 22548360 22b9e044 230cc890 753 DEP[01] 8 22548360 22b9e078 22f930f4 25 DEP[01] 9 22548360 22b9e0ac 223291c0 30 DEP[01] 10 22548360 22b9e0e0 21d41d38 857 DEP[01] 11 22548360 22b9e114 2268f7b0 116 DEP[01] 12 22548360 22b9e148 21e93928 103 DEP[01] 13 22548360 22b9e17c 22653a58 76 DEP[01] 14 22548360 22b9d9c4 223c8f08 485 DEP[01] 15 22548360 22b9d9f8 23740f18 5236 DEP[01] 16 22b9dd90 22b9da2c 2359d480 5200 DEP[01] 17 22b9dd90 22b9da60 23776aa8 4819 DEP[01] 18 22b9dd90 22b9da94 23755410 4828 DEP[01] 19 22b9dd90 22b9dac8 237bf360 56 DEP[01] 20 22b9dd90 22b9dafc 2377d704 331 DEP[01] 21 22b9dd90 22b9db30 236ae80c 513 DEP[01] 22 22b9dd90 22b9db64 2306ec60 688 DEP[01] 23 22b9dd90 22b9db98 22189a74 71 DEP[01] 24 22b9dd90 22b9dbcc 21ee84d0 897 DEP[01] 25 22b9dd90 22b9dc00 237798b0 2249 DEP[01] 26 22b9dd90 22b9dc34 234d42b8 8759 DEP[01] 27 22b9dd90 22b9dc68 22da34f4 8639 DEP[01] 28 22b9dd90 22b9dc9c 221deed8 36 DEP[01] 29 22b9dd90 22b9dcd0 23104e20 92 DEP[01] 30 22b9dd90 22b9dd04 2253f11c 107 DEP[01] 31 22b9dd90 22b9dd38 2268e440 201 DEP[01] 32 221c3c08 221c383c 231dd6e4 213 DEP[01] 33 221c3c08 221c3870 22247aec 3039 DEP[01] 34 221c3c08 221c38a4 233a725c 566 DEP[01] 35 221c3c08 221c38d8 22783214 1177 DEP[01] 36 221c3c08 221c390c 21d3a7d4 1190 DEP[01] 37 221c3c08 221c3940 2273af80 1493 DEP[01] 38 221c3c08 221c3974 2219d3c4 23 DEP[01] 39 221c3c08 221c39a8 228be078 203 DEP[01] 40 221c3c08 221c39dc 23782890 54 DEP[01] 41 221c3c08 221c3a10 22c684d0 785 DEP[01] 42 221c3c08 221c3a44 2361cce8 221 DEP[01] 43 221c3c08 221c3a78 21cdde44 1122 DEP[01] 44 221c3c08 221c3aac 22676080 1097 DEP[01] 45 221c3c08 221c3ae0 225c569c 935 DEP[01] 46 221c3c08 221c3b14 22f23550 1236 DEP[01] 47 221c3c08 221c3b48 22c8e8ac 176 DEP[01] 48 221c3bbc 221c3b7c 230eb7fc 83 DEP[01] READ ONLY DEPENDENCIES: count=1 size=16 dependency# table reference handle flags
• -------- --------- -------- ------------------- 0 225483ac 2254812c 22b73a0c /ROD/KPP[60] TRANSLATIONS: count=1 size=16 original final
  • -------- 0 22eba44c DATA BLOCKS: data# heap pointer status pins change whr alloc(K) size(K)
    • -------- -------- --------- ---- ------ --- -------- -------- 0 234b0efc 22548140 I/P/A/-/- 0 NONE 00 4.77 5.23 6 22b9ddf4 227f88f0 I/P/A/-/- 1 NONE 00 2403.36 2415.89 *** 2008-06-23 08:13:51.705 kwqavqueue : SCHEDULER$_JOBQ *** 2008-06-23 08:14:18.701 kewuesch: Unable to reset schedule since AWR is not open kewuesch: Unable to reset schedule since AWR is not open

Can someone enlighten on the meanings of all these contents?

Anything serious / missing / misconfigured? (It is a fresh new database - after "create database" + catalog.sql + catproc.sql executed).

Thank you very much.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 23 2008 - 21:39:23 CDT