ITPub博客

首页 > 数据库 > Oracle > Redo Logging I/O-Related Wait Events

Redo Logging I/O-Related Wait Events

原创 Oracle 作者:jelephant 时间:2015-10-27 15:42:47 0 删除 编辑

'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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 11gRAC之service
请登录后发表评论 登录
全部评论

注册时间:2013-12-07

  • 博文量
    143
  • 访问量
    626774