ORACLE 锁表处理

--查看锁表SESSION
SELECT DB.OWNER,
       SESS.USERNAME,
       DB.OBJECT_NAME,
       DB.OBJECT_TYPE,
       SESS.SID,
       SESS.SERIAL#,
       SESS.MACHINE,
       SESS.PROGRAM,
       SESS.LOGON_TIME,
       SESS.SERVICE_NAME
  FROM V$LOCKED_OBJECT LOC --锁对象表
  JOIN V$SESSION SESS --SESSION表
    ON LOC.SESSION_ID = SESS.SID
  JOIN DBA_OBJECTS DB --所有对象
    ON LOC.OBJECT_ID = DB.OBJECT_ID;

--结束SESSION进程
ALTER SYSTEM KILL SESSION 'SID,SERIAL#';