Redo Logging I/O-Related Wait Events

'log file sequential read' and 'log file single write'

Both these Wait Events are I/O-related so they are likely to appear together with 'log file parallel write' if there is I/O contention on the redo logs. Follow the same guidelines for tuning them.

'switch logfile command' ,'log file switch completion' and 'log file switch (clearing log file)'

More LGWR I/O-related Wait Events, tune as before.

'log file switch (checkpoint incomplete)'

This Wait Event occurs when checkpointing activities are not occurring quickly enough. 
For guidelines on tuning checkpoint operations please refer to:

Document 147468.1  Checkpoint Tuning and Troubleshooting Guide
Document 76713.1  8i Parameters that Influence Checkpoints

'log switch/archive' and 'log file switch (archiving needed)'

These Wait Events occur when archiving is enabled and indicate that archiving is not performing fast enough.
For guidelines on tuning archiving operations please refer to:

Document 45042.1  Archiver Best Practices

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29337971/viewspace-1816627/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29337971/viewspace-1816627/