SELECT
s1.USERNAME blkg_user,
s1.MACHINE blkg_machine,
s1.SID blkg_sid,
s1.SERIAL# blkg_serialnum,
s1.SID
||','
||s1.SERIAL# kill_string,
s2.USERNAME wait_user,
s1.MACHINE wait_machine,
s2.SID wait_sid,
s1.SERIAL# wait_serialnum,
lo.OBJECT_ID blkd_object_id,
do.OWNER obj_own,
do.OBJECT_NAME obj_name
FROM
v$lock l1,
v$session s1,
v$lock l2,
v$session s2,
v$locked_object lo,
dba_objects DO
WHERE
s1.SID=l1.SID
AND s2.SID=l2.SID
AND l1.ID1=l2.ID1
AND s1.SID=lo.SESSION_ID
AND lo.OBJECT_ID=do.OBJECT_ID
AND l1.BLOCK=1
AND l2.REQUEST>0;
|