Tag Archives: log file sync

单用户系统特征

偶然发现一个标准的单用户系统,和大家分享一下。 其实判断依据很简单,并不是通过会话数,或者检查是否只有一个非系统会话实现的,事实上是通过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

Posted in ORACLE | Tagged , , | Leave a comment