Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Log File Sync

729084Dec 6 2009 — edited Dec 22 2009
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 19 2010
Added on Dec 6 2009
12 comments
1,677 views