select s.sid,s.serial# from v$locked_object lo,dba_objects ao, v$session s where ao.object_id=lo.object_id and lo.session_id=s.sid
上面命令查到两个值传入下面的命令中执行即可
alter system kill session '49,54662'
select s.sid,s.serial# from v$locked_object lo,dba_objects ao, v$session s where ao.object_id=lo.object_id and lo.session_id=s.sid
上面命令查到两个值传入下面的命令中执行即可
alter system kill session '49,54662'