1.select * from v$session where blocking_session is not null
blocking_session是阻塞用户的sid
2.select * from dba_waiters
HOLDING_SESSION持有锁的用户
WAITING_SESSION等待锁的用户
3.select a.sid hold_session,
b.sid wait_session,
a.lmode hold_lmode,
b.lmode wait_lmode,
a.id1 object_id,
a.id2,
b.request
from (select *
from v$lock
where block = 1
and type in ('TM', 'TX')) a,
(select *
from v$lock
where request <> 0
and type in ('TM', 'TX')) b
where a.id1 = b.ID1
and a.id2 = b.ID2
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/633084/viewspace-1025074/ ，如需转载，请注明出处，否则将追究法律责任。
