查询锁表

--查询锁表语句 SELECT   A.USERNAME,   A.MACHINE,   A.PROGRAM,   A.SID,   A.SERIAL#,   A.STATUS,   C.PIECE,   C.SQL_TEXT FROM   V$SESSION A,   V$SQLTEXT C WHERE   A.SID IN ( SELECT DISTINCT T2.SID FROM V$LOCKED_OBJECT T1, V$SESSION T2 WHERE T1.SESSION_ID = T2.SID )   AND A.SQL_ADDRESS = C.ADDRESS ( + ) ORDER BY   C.PIECE;     --查询锁表SQL SELECT   sess.sid,   sess.serial#,   lo.oracle_username, -- 登陆账号名称   lo.os_user_name,    -- 登录电脑名称   ao.object_name,     -- 被锁表名   lo.locked_mode      -- 死锁级别 FROM   v$locked_object lo,   dba_objects ao,   v$session sess WHERE   ao.object_id = lo.object_id   AND lo.session_id = sess.sid;   --杀掉锁表进程 alter system kill session '5,421';