锁表SQL

SELECT SESS.sid,
       SESS.serial#,
       LO.oracle_username,
       LO.os_user_name,
       AO.OBJECT_NAME,
       LO.locked_mode
 FROM V$LOCKED_OBJECT LO,
       DBA_OBJECTS AO,
       V$SESSION SESS
  WHERE AO.object_id = LO.object_id AND LO.session_id = SESS.sid;

杀掉锁表进程（SID,SERIAL#）

ALTER SYSTEM kill SESSION '26,63';