Friday 26 February 2016

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


Remarks:

  •         Reference Note# 34583.1

No comments: