Saturday, April 30, 2011

Warning: log write time

Symptoms:

Oracle 10.2.0.4 on Solaris sparc 64bit (Solaris 10)
===========================================================
Warning: log write time 930ms, size 1176KB
*** 2011-04-14 10:00:06.961
Warning: log write time 3170ms, size 3651KB
*** 2011-04-14 10:00:10.684
Warning: log write time 790ms, size 969KB


Explanation:


The above warning messages has been introduced in 10.2.0.4 patchset. This warning message

will be generated only if the log write time is more than 500 ms and it will be written to the lgwr trace file.

These messages are very much expected in 10.2.0.4 database in case the log write is more than 500 ms.
This is a warning which means that the write process is not as fast as it intended to be.