有网友反映windows 2003 上的10.2.0.4数据库，MMON的Slave后台进程报带有NEWLEN: MESSAGES的相关日志，如:
*** ACTION NAME:(Auto ADDM Slave Action) 2011-09-09 18:00:12.053 *** MODULE NAME:(MMON_SLAVE) 2011-09-09 18:00:12.053 *** SERVICE NAME:(SYS$BACKGROUND) 2011-09-09 18:00:12.053 *** SESSION ID:(797.606) 2011-09-09 18:00:12.053 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0
这一般是由于10.2.0.4上已经confirmed的bug:”Bug 6972843 – Unnecessary trace files with “[kdl_trim]: newlen” text in them [ID 6972843.8]”所引起的，在bug目前确认仅在10.2.0.4上发生，而到10.2.0.4.1中已经被修复了。
主要是MMON的辅助slave进程会不必要地输出如”[kdl_trim]: newlen: 0″的日志信息：
Unnecessary trace files may be generated with entries that read:'[kdl_trim]: newlen: '. Hdr: 9600827 10.2.0.4 RDBMS 10.2.0.4 RAM LOBS PRODID-5 PORTID-212 Abstract: [KDL_TRIM]: NEWLEN: MESSAGES IN MMON SLAVES TRACES PROBLEM: -------- MMON slave processes traces contains the following entries despite patch 6972843 applied *** NAME:(Auto ADDM Slave Action) 2010-04-14 06:00:42.899 *** NAME:(MMON_SLAVE) 2010-04-14 06:00:42.899 *** NAME:(SYS$BACKGROUND) 2010-04-14 06:00:42.899 *** ID:(2472.45569) 2010-04-14 06:00:42.899 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 DIAGNOSTIC ANALYSIS: -------------------- - Opatch contains patch 6972843 applied WORKAROUND: ----------- none RELATED BUGS: ------------- Bug 6972843 - HOURLY TRACE FILE CREATED IN BDUMP FOR AUTO ADDM SLAVE ACTION
该bug可以被忽略，但是如果日志产生过于频繁的话可以考虑升级10.2.0.4的PSU或者直接升级到10.2.0.5。
Comment