查詢鎖表 - 誰鎖住了我的表

tolywang發表於2012-05-10

select p.SPID, p.SERIAL# as proserial,p.PID as pid, s.SID as sessionid,      
s.SERIAL# as sessseri, s.USERNAME,s.OSUSER,s.MACHINE,
      s.PROGRAM,s.ACTION,s.STATUS
from v$session s, v$process p
where s.PADDR=p.ADDR and s.SID in (select session_id from v$locked_object  where object_id in (select object_id from dba_objects
where wner='&schema' and object_name='&name'));

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/35489/viewspace-748350/，如需轉載，請註明出處，否則將追究法律責任。

相關文章