Re: Increase in 'log file sync' waits while 'log file parallel write' remains unchanged
From: Srivenu Kadiyala <srivenu_at_hotmail.com>
Date: Fri, 2 Oct 2009 12:49:54 -0700 (PDT)
Message-ID: <81ce4266-ae85-47fb-9c3b-5f9ab62689a9_at_u16g2000pru.googlegroups.com>
There is a bug in 9i due to which lgwr reports erroneous values for "log file parallel write".
See Jonathan's note on this.
http://www.jlcomp.demon.co.uk/log_file_writes.html
Date: Fri, 2 Oct 2009 12:49:54 -0700 (PDT)
Message-ID: <81ce4266-ae85-47fb-9c3b-5f9ab62689a9_at_u16g2000pru.googlegroups.com>
There is a bug in 9i due to which lgwr reports erroneous values for "log file parallel write".
See Jonathan's note on this.
http://www.jlcomp.demon.co.uk/log_file_writes.html
Use OS tracing commands like truss to get the lgwr io timings.
regards
srivenu
Received on Fri Oct 02 2009 - 14:49:54 CDT