Oracle Kill被锁进程

(一)查询被锁的表
select t2.username,
       t2.sid,
       t2.serial#,
       t3.object_name,
       t2.OSUSER,
       t2.MACHINE,
       t2.PROGRAM,
       t2.LOGON_TIME,
       t2.COMMAND,
       t2.LOCKWAIT,
       t2.SADDR,
       t2.PADDR,
       t2.TADDR,
       t2.SQL_ADDRESS,
       t1.LOCKED_MODE
  from v$locked_object t1, v$session t2, dba_objects t3
 where t1.session_id = t2.sid
   and t1.object_id = t3.object_id
 order by t2.logon_time;
 
(二)查询被锁的进程所执行语句
SELECT SQL_TEXT
     FROM V$SQLTEXT A
    WHERE (A.HASH_VALUE, A.ADDRESS) IN
          (SELECT DECODE(SQL_HASH_VALUE, 0, PREV_HASH_VALUE, SQL_HASH_VALUE),
                  DECODE(SQL_HASH_VALUE, 0, PREV_SQL_ADDR, SQL_ADDRESS)
             FROM V$SESSION B
            WHERE B.SID = '171') /* 此处171为SID*/
    ORDER BY PIECE ASC;