Oracle Warning: log write elapsed time

log writer debug module

-bash-3.2$ cat aptdb_lgwr_4210.trc
Trace file /aptus/oracle/diag/rdbms/aptdb/aptdb/trace/aptdb_lgwr_4210.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /aptus/oracle/product/11.2.0/db_1
System name: Linux
Node name: apt-rdbms-01.xxx.co.uk
Release: 2.6.18-238.12.1.el5
Version: #1 SMP Tue May 31 13:22:04 EDT 2011
Machine: x86_64
Instance name: aptdb
Redo thread mounted by this instance: 1
Oracle process number: 11
Unix process pid: 4210, image: oracle@apt-rdbms-01.XXXX.co.uk (LGWR)


*** 2011-09-09 13:48:39.779
*** SESSION ID:(189.1) 2011-09-09 13:48:39.779
*** CLIENT ID:() 2011-09-09 13:48:39.779
*** SERVICE NAME:(SYS$BACKGROUND) 2011-09-09 13:48:39.779
*** MODULE NAME:() 2011-09-09 13:48:39.779
*** ACTION NAME:() 2011-09-09 13:48:39.779


*** TRACE FILE RECREATED AFTER BEING REMOVED ***


*** 2011-09-09 13:48:39.695
Warning: log write elapsed time 851ms, size 1KB
(set event 10468 level 4 to disable this warning)

*** 2011-09-09 13:55:45.549
Warning: log write elapsed time 1460ms, size 1KB
(set event 10468 level 4 to disable this warning)





-bash-3.2$ pwd
/aptus/oracle/diag/rdbms/aptdb/aptdb/trace
-bash-3.2$ cd /aptus/oracle/product/11.2.0/db_1/rdbms/mesg/


-bash-3.2$ ls -ltr oraus.msg
-rw-r--r-- 1 oracle oinstall 4777005 Aug 14 2009 oraus.msg


-bash-3.2$ cat oraus.msg|grep "log writer debug module"
10468, 00000, "log writer debug module"



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



warning indicates slow write to the log files , you can put log file on the separate disk .It would reduce the load on the disk



You can disable the trace by following

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