sql-db locks

SELECT DECODE(request,0,'Holder: ',' Waiter: ')||a.sid sess,
decode(request,0,to_char(a.inst_id),' '||to_char(a.inst_id)) inst,b.audsid ,
id1, id2, lmode, request, a.type, a.sid,
b.sql_hash_value hash,module,round(last_call_et/60,0) min ,
b.audsid
FROM gV$LOCK a, gv$session b
WHERE (id1, id2, a.type) IN
(SELECT id1, id2, type FROM gV$LOCK WHERE request>0)
and a.sid = b.sid
and a.inst_id = b.inst_id
ORDER BY id1, request;