查看数据库中的表锁.sql

来自「oracle 10g管理员管理数据库SQL,好资料！」· SQL 代码 · 共 45 行

SELECT A.OWNER,
       
       A.OBJECT_NAME,
       
       B.XIDUSN,
       
       B.XIDSLOT,
       
       B.XIDSQN,
       
       B.SESSION_ID,
       
       B.ORACLE_USERNAME,
       
       B.OS_USER_NAME,
       
       B.PROCESS,
       
       B.LOCKED_MODE,
       
       C.MACHINE,
       
       C.STATUS,
       
       C.SERVER,
       
       C.SID,
       
       C.SERIAL#,
       
       C.PROGRAM

  FROM ALL_OBJECTS A,
       
       V$LOCKED_OBJECT B,
       
       SYS.GV_$SESSION C

 WHERE (A.OBJECT_ID = B.OBJECT_ID)
      
   AND (B.PROCESS = C.PROCESS)

--  AND  

 ORDER BY 1, 2;