①得到sid,ser
select b.owner, b.object_name, l.session_id sid, s.SERIAL# ser
from v$locked_object l, dba_objects b, v$session s
where b.object_id = l.object_id
and l.session_id = s.sid;
②把sid,ser放到这个语句杀死进程
alter system kill session 'SID,SER';
如果第二步执行不了,请重新连接一下数据库.