library cache lock 阻塞进程查询

 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

/

SELECT sid,event, sql_text

  FROM v$session, v$sqlarea

 WHERE v$session.sql_address = v$sqlarea.address AND sid =&sid;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15747463/viewspace-772864/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15747463/viewspace-772864/