杀锁表线程

1. 查询那些被锁了

SELECT 
       s.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 logon_time desc, s.serial#;

2. 杀掉

alter system kill session 'sid,serial';