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