oracle锁表查询及解锁kill进程

SELECT * FROM v$locked_object A;

 

--查看那个表被锁

SELECT

      b.OWNER,

      b.OBJECT_NAME,

      a.SESSION_ID,

      a.LOCKED_MODE

 FROM v$locked_object a,

      Dba_Objects b

WHEREa.OBJECT_ID=b.OBJECT_ID;

 

 

--查看是哪个session引起的

SELECT

      b.USERNAME,

      b.SID,

      b.SERIAL#,

      b.LOGON_TIME

 FROM v$locked_object a,

      v$session b

WHEREa.SESSION_ID=b.SID

ORDERBY b.LOGON_TIME;

 

--杀掉对应进程

ALTERSYSTEMKILLSESSION'sid,serial#';