Skip to Main Content
  • Questions
  • how can we reduce wait event Log file sync

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, SRINIVASARAO.

Asked: December 10, 2015 - 9:57 am UTC

Last updated: December 14, 2015 - 6:48 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Hi ,

We are facing wait event LOG FILE SYNC in our production database 2 node RAC 11gR2.
one of the top wait event in AWR Report. How can we reduce wait event Log file sync.
please suggest.

and Connor said...

log file sync is typically caused by three things

1) committing takes too long

Check 'log file parallel write'. If that's a large percentage of the 'log file sync' time, then you might have an I/O performance issue. Redo writes should be expected to be 1ms or less on modern hardware.

2) committing too frequently

(Roughly speaking) when one person commits, "everyone" else wanting to commit waits on 'log file sync'. If your application commits excessively, this delay can mount up. But also note - this can mean that 'log file sync' is high on your list of waits, but not necessarily a problem that needs to be fixed.

3) resource pressure

If the server is overloaded (in particular on CPU), the lgwr process can struggle for resources, which slows it down...which slows all commits down.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.