查看enqueue

select b.sid,b.serial#,b.username,b.machine,a.event,a.wait_time,
chr(bitand(a.p1,-16777216)/16777215)||chr(bitand(a.p1, 16711680)/65535) "Enqueue Type"
from v$session_wait a,v$session b
where a.event not like 'SQL*N%' and a.event not like 'rdbms%' and a.sid=b.sid
and b.sid>8 and a.event='enqueue'
order by b.username;

查看锁阻塞者和等待者

SELECT DECODE(request, 0, 'Holder :', 'Waiter :') || sid sess,
id1,
id2,
lmode,
2 request,
type
FROM V$LOCK
WHERE (id1, id2, type) IN
(SELECT id1, id2, type FROM V$LOCK WHERE request > 0)
ORDER BY id1, request;