Wait Event:
log file parallel write
Possible Causes:
- LGWR waits while writing the contents of the redo log buffer cache to the online log files on the disk
- I/O wait on subsystem 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 to redo log files
- Use faster disks to 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.
REMARKS:
- Reference Note# 34583.1
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8