查询锁表

--查询锁表语句

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';