等待时间描述:
Waiting for a log switch because the session cannot wrap into the next log. Wrapping cannot be performed because the checkpoint for that log has not completed.
当你的日志组都写完以后,LGWR 试图写第一个log file,如果这时数据库没有完成写出记录在第一个log file 中的dirty 块时(例如第一个检查点未完成),该等待事件出现。此时online log状态全部是active状态
该等待事件通常表示你的DBWR 写出速度太慢或者IO 存在问题或者正在执行批量插入作业
Top 5 Timed Events
Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
log file switch (checkpoint incomplete) | 135,745 | 127,851 | 942 | 52.1 | Configuration |
enq: SQ - contention | 12,964 | 36,530 | 2,818 | 14.9 | Configuration |
read by other session | 1,123,797 | 17,965 | 16 | 7.3 | User I/O |
db file sequential read | 1,036,098 | 17,535 | 17 | 7.1 | User I/O |
buffer busy waits | 19,299 | 15,912 | 825 | 6.5 | Concurrency |
解决办法
调整参数db_writer_processes增加额外的DBWR
增加你的日志组或日志文件大小
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15747463/viewspace-758066/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15747463/viewspace-758066/