Oracle表锁死处理

 

--查询被锁的表
SELECT * from v$session where SID in (
   SELECT lockObj.SESSION_ID
    FROM V$LOCKED_OBJECT lockObj left join DBA_OBJECTS objs
                     on lockObj.OBJECT_ID = objs.object_id
          LEFT JOIN v$session sess
                    on lockObj.SESSION_ID = sess.SID)

--kill session
ALTER SYSTEM KILL SESSION 'SID,SERIAL#';