Tag Archives: Waiting for additional work from the logfile

客户一个并不繁忙的数据库出现长时间Streams miscellaneous event等待。     数据库版本是RAC 11.2.0.2 for Linux X64，其中一个节点的TOP 5等待信息为： Event Waits Time(s) Avg wait (ms) % DB time Wait Class Streams miscellaneous event 62,377 31,274 501 93.26 Other DB CPU 1,887 5.63 log file sequential read 648,206 276 … Continue reading →