Wednesday, January 20, 2010

11g R1 lgwr trace file

cat VAS11GT_lgwr_2531.trc

*** 2010-01-12 06:58:45.760
Warning: log write elapsed time 1757ms, size 1KB
(set event 10468 level 4 to disable this warning)


from oraus.msg file
dev09:VAS11GT:/software/oravas11/product/11.2.0/rdbms/mesg> ll oraus.msg
-rw-r--r-- 1 oravas11 oravas11 4777736 Dec 15 19:33 oraus.msg

10468, 00000, "log writer debug module"
// *Document: NO
// *Cause:
// *Action: Set this event to the appropriate level for log writer debugging.


--set for event

ALTER system SET EVENTS '10468 trace name context forever, level 4';



No more such warning message.