Wait Event: log file parallel write

Wait Event: log file parallel write

Possible Causes:

• LGWR waits while writing contents of the redo log buffer cache to the online log files on disk
• I/O wait on sub system holding the online redo log files

Actions

• Reduce the amount of redo being generated
• Do not leave tablespaces in hot backup mode for longer than necessary
• Do not use RAID 5 for redo log files
• Use faster disks for redo log files
• Ensure that the disks holding the archived redo log files and the online redo log files are separate so as to avoid contention
• Consider using NOLOGGING or UNRECOVERABLE options in SQL statements

Ref:
Reference Note# 34583.1