oracle数据库查询锁表及杀进程

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)

 ORDER BY 1, 2;

 

 

SELECT 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)

ORDER BY 1, 2;

 

 

 alter system kill session 'sid, serial#'