Log File Sync
729084Dec 6 2009 — edited Dec 22 2009Hi,
I am trying to analyze some data here as we are experiencing commit spikes and log file sync is showing up as the top wait.
From AWR report we are seeing
log file sync wait - 516 ms
log file parallel write - 91 ms
redo write time - 340 ms
user commits 3.9
So there are
340/3.9 = 87.1 ms per user commit of redo write time
and thus
516 - 87.1 -91 = 337.9 ms
Thus 337.9 ms are spent during LGWR's post processing. Does anyone have any insight on if this is the issue and what might be causing this?
I am assuming this is at the OS level? We have trussed the LGWR process and it is showing write times of over 500ms. Could the fact the log
buffer is not sized properly be causing us the pain as there is memory contention going on?
Cheers