Oracle数据库如何为表解锁

   1、执行下面的SQL，找到被锁的表： 

   select b.owner table_owner,b.object_name,c.username,c.sid,c.serial#
     from v$locked_object a,dba_objects b,v$session c
    where a.object_id=b.object_id and c.sid=a.session_id;

   2、根据查询结果中每条记录的sid和serial#杀掉SESSION： 

       alter system kill session '[sid],[serial#]';