Saturday, April 30, 2011

Warning: log write time


Oracle 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


The above warning messages has been introduced in 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 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.