Kill被锁的表

SELECT a.object_id, b.object_name, a.session_id, a.oracle_username,
       a.os_user_name, a.process, a.locked_mode
  FROM v$locked_object a, dba_objects b
 WHERE a.object_id = b.object_id;

 

SELECT   t2.username, t2.SID, t2.serial#, t2.logon_time
    FROM v$locked_object t1, v$session t2
   WHERE t1.session_id = t2.SID
ORDER BY t2.logon_time;

 

 

ALTER SYSTEM KILL SESSION 'SID, serial#';