oracle 查询锁表

oracle9i 时用到的

从以前日志中找到的

 

现在估计用不到了

 {
---------------------------------- -------------------------------
SELECT SSN.SADDR,pro.spid,SSN.MACHINE,SSN.TERMINAL,LCK.SESSION_ID,SSN.PROGRAM,ssn.logon_time,OBJ.OBJECT_NAME,SSN.STATUS,LCK.OBJECT_ID,OBJ.OWNER,OBJ.SUBOBJECT_NAME,OBJ.OBJECT_ID ,SSN.SID,SSN.USERNAME,SSN.PROCESS
FROM V$LOCKED_OBJECT LCK,ALL_OBJECTS OBJ , GV$SESSION SSN,v$process pro
WHERE LCK.OBJECT_ID= OBJ.OBJECT_ID
   AND LCK.SESSION_ID=SSN.SID
   and ssn.paddr=pro.addr
ORDER BY SSN.SID
}