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
Remarks:
- Reference Note# 34583.1
No comments:
Post a Comment