找出阻塞的用户三种方法

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

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/633084/viewspace-1025074/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/633084/viewspace-1025074/