奇怪的db file sequential read

hhan_01

做过trace,但是level 12也只能显示已有的等待事件,而当前还在等待的似乎被hung住的块读也不会写入到trace中,因为他一直没有完成

Yong Huang

110662 seconds is definitely too long. Technically, seconds_in_wait is not a good name for that column. Section 8 of http://yong321.freeshell.org/computer/OracleMisnomers.txt talks about it. If the session is using CPU right now, it means the session waited some time starting 110662 seconds ago. If it's still waiting, that's bad. Either way it's bad. Something is wrong. Storage? Memory? I don't know.

Yong Huang

sqysl

确实是个奇怪的问题:
1、介质内存问题？？？

sqysl

确实是个奇怪的问题:
1、介质内存问题？？？
2、与其他会话的死锁？？？
3、僵尸会话？？？
围绕这几个方面做一下测试判断，大家一起讨论。