oracle find blocking session

show current session id

    select sid from v$mystat where rownum=1;

show blocking session

    select blocking_session, sid, serial#, wait_class, seconds_in_wait from v$session where blocking_session is not NULL order by blocking_session; 
posted on 2013-11-06 14:32  lpthread  阅读(476)  评论(0编辑  收藏  举报