Re: Increase in 'log file sync' waits while 'log file parallel write' remains unchanged
Date: Mon, 21 Sep 2009 16:34:08 -0700 (PDT)
Message-ID: <72ca58c8-2383-4e44-915a-49afe12a0306_at_y20g2000vbk.googlegroups.com>
On Sep 21, 6:52 pm, vsevolod afanassiev
<vsevolod.afanass..._at_gmail.com> wrote:
snip
> We have small 9.2.0.8 database on AIX, from time to time it
> experiences waits
> on 'log file sync'. I am unable to explain these waits:
> - There is no increase in the number or size of transaction
> - While average wait on 'log file sync' increases from 10ms to 124ms
> average wait on 'log file parallel write' does not change much -
> approx 0.05 ms.
Do you have available cpu time on this system when the log file waits shoot up?
Unless you are showing some signs of severe cpu starvation ( that might have been missed possibly ) I think you gotta check out the IO subsystem.
My databases get about .5 ms for log file sync ... 10 ms is ugly and 100 ms just ouch.
Local storage or SAN? Can you get some iostat information during the bad times? Received on Mon Sep 21 2009 - 18:34:08 CDT