Redo Logging I/O-Related Wait Events

jelephant發表於2015-10-27
原文網址 : http://blog.itpub.net/29337971/viewspace-1816627/
AI

'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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章