查看oracle锁，kill掉对应session

--查看锁对应的SID, SERIAL#
SELECT S.SID,
       S.SERIAL#,
       L.ORACLE_USERNAME,
       L.OS_USER_NAME,
       O.OBJECT_NAME,
       L.LOCKED_MODE
  FROM V$LOCKED_OBJECT L
  JOIN V$SESSION S
    ON L.SESSION_ID = S.SID
  JOIN DBA_OBJECTS O
    ON L.OBJECT_ID ON O.OBJECT_ID;

--根据SID, SERIAL#，把SESSION KILL掉
ALTER SYSTEM KILL SESSION "145,77";
--不能马上生效时加上IMMEDIATELY
ALTER SYSTEM KILL SESSION "145,77" IMMEDIATELY;

SELECT * FROM SYS.V_$LOCKED_OBJECT;--V$LOCKED_OBJECT
SELECT * FROM SYS.V_$SESSION;--V$SESSION
SELECT * FROM DBA_OBJECTS;

http://www.iteye.com/topic/571315

用plsql 解决 oracle 表死锁问题