执行 
select b.owner,
       b.object_name,
       a.session_id,
       a.locked_mode,
       c.serial#,
       c.sid || ',' || c.serial#
  from v$locked_object a, dba_objects b, v$session c
 where b.object_id = a.object_id
   And a.session_id = c.sid
object_id 
And a.session_id = c.sid 
查看锁表的会话id,
执行 alter system kill session 'sid,serial#' immediate; 杀掉进程中的会话