tomas.papp.me.u'know

Wait details:

select
 distinct
 ses.ksusenum sid, ses.ksuseser serial#, ses.ksuudlna username,ses.ksuseunm machine,
 ob.kglnaown obj_owner, ob.kglnaobj obj_name
 ,pn.kglpncnt pin_cnt, pn.kglpnmod pin_mode, pn.kglpnreq pin_req
 , w.state, w.event, w.wait_Time, w.seconds_in_Wait
 -- lk.kglnaobj, lk.user_name, lk.kgllksnm,
 --,lk.kgllkhdl,lk.kglhdpar
 --,trim(lk.kgllkcnt) lock_cnt, lk.kgllkmod lock_mode, lk.kgllkreq lock_req,
 --,lk.kgllkpns, lk.kgllkpnc,pn.kglpnhdl
 from
 x$kglpn pn, x$kglob ob,x$ksuse ses
 , v$session_wait w
 where pn.kglpnhdl in
 (select kglpnhdl from x$kglpn where kglpnreq >0 )
 and ob.kglhdadr = pn.kglpnhdl
 and pn.kglpnuse = ses.addr
 and w.sid = ses.indx
 order by seconds_in_wait desc
 /

Holders/waiters

select
 distinct
 ses.ksusenum sid, ses.ksuseser serial#, ses.ksuudlna username,KSUSEMNM module,
 ob.kglnaown obj_owner, ob.kglnaobj obj_name
 ,lk.kgllkcnt lck_cnt, lk.kgllkmod lock_mode, lk.kgllkreq lock_req
 , w.state, w.event, w.wait_Time, w.seconds_in_Wait
 from
 x$kgllk lk, x$kglob ob,x$ksuse ses
 , v$session_wait w
 where lk.kgllkhdl in
 (select kgllkhdl from x$kgllk where kgllkreq >0 )
 and ob.kglhdadr = lk.kgllkhdl
 and lk.kgllkuse = ses.addr
 and w.sid = ses.indx
 order by seconds_in_wait desc
 /