【等待事件】log file switch (checkpoint incomplete)

等待时间描述:

  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/