1、查询出那个表被锁
select object_name,machine,s.sid,s.serial#
from v$locked_object l,dba_objects o ,v$session swhere l.object_id = o.object_id and l.session_id=s.sid;
2、kill 杀死线成id
alter system kill session '408,3962';1、查询出那个表被锁
select object_name,machine,s.sid,s.serial#
from v$locked_object l,dba_objects o ,v$session swhere l.object_id = o.object_id and l.session_id=s.sid;
2、kill 杀死线成id
alter system kill session '408,3962';