Wait Event: log file sync

Wait Event: log file sync

Possible Causes:

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

Actions

• Tune LGWR to get good throughput todisk eg: Do not put redo logs on RAID5
• Reduce overall number of commits by batching transactions so that there are fewer distinct COMMIT operations

Ref:
Reference Note# 34583.1