qblocking.sql
0
The qblocking script will what sessions are currently being blocked, use the qsid.sql script to see what the user is running
SQL
select l1.sid, ‘ IS BLOCKING ‘, l2.sid
from v$lock l1, v$lock l2
where l1.block =1 and l2.request > 0
and l1.id1=l2.id1
and l1.id2=l2.id2;
Output