查看锁表信息及删除锁表线程SQL

--查看锁表信息
SELECT
L.SESSION_ID SID,
S.SERIAL#,
L.LOCKED_MODE,
L.ORACLE_USERNAME,
L.OS_USER_NAME,
S.MACHINE,
S.TERMINAL,
O.OBJECT_NAME,
S.LOGON_TIME  FROM V$LOCKED_OBJECT L, ALL_OBJECTS O, V$SESSION S  WHERE L.OBJECT_ID = O.OBJECT_ID AND L.SESSION_ID = S.SID ORDER BY SID, S.SERIAL# ;

--删除锁表线程
ALTER system KILL session 'SID,SERIAL';