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; 

转载于:https://www.cnblogs.com/lpthread/p/3410508.html