tomas.papp.me.u'know

tento skript sa mi osvedcil ako celkom handy tak som ho trochu upravil aby zobrazoval vsetky podstatne informacie ktore v danej chvili treba vediet

col object_name format a20
column sess format A20
col schemaname format a15

SELECT substr(DECODE(request,0,'Holder: ','Waiter: ')||l.sid,1,12) sess,s.schemaname,
l.id1,o.object_name, l.id2, l.lmode, l.request, l.type, l.inst_id,w.seconds_in_wait
FROM GV$LOCK l
left join gv$session s on s.sid=l.sid and l.inst_id=s.inst_id
left join dba_objects o on l.id1=o.object_id
left join v$session_wait w on s.sid=w.sid
WHERE (l.id1, l.id2, l.type) IN
(SELECT id1, id2, type FROM GV$LOCK WHERE request>0)
ORDER BY sess,id1;