Tag Archives: log file parallel write

偶然发现一个标准的单用户系统，和大家分享一下。 其实判断依据很简单，并不是通过会话数，或者检查是否只有一个非系统会话实现的，事实上是通过TOP 5等待得出的结论： Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class CPU time 79,791 78.7 log file sync 61,567,574 58,918 1 58.1 Commit log file parallel write 61,726,240 58,053 1 57.3 System I/O db file sequential read … Continue reading →