10g 采用v$session快速查找阻塞

10g的v$session视图增加了blocking_session,blocking_session_status两列，通过这两列，我们可以很快查找阻塞，who is blocking who?

 

SELECT sid, blocking_session, username, blocking_session_status
FROM v$session
ORDER BY blocking_session;