log file sync

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

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

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