Log file sync

Possible Causes:

•          Oracle foreground processes are waiting for a COMMIT or ROLLBACK to complete.

Actions:

• Tune LGWR to get good throughput to  disk eg: Do not put redo logs on RAID5.
• Reduce overall number of commits by batching transactions so that there are fewer distinct COMMIT operations.
• Check to see if redologs are large enough. Enlarge the redologs so the logs switch between 15 to 20 minutes.

Remarks:

•          Reference Note# 34592.1
•          High Waits on log file sync Note# 125269.1
•          Tuning the Redolog Buffer Cache and Resolving Redo Latch Contention Note# 147471.1