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;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;