一.单独删除某个进程
1.查询目前数据库存在的进程
select b.owner, b.object_name, a.session_id, a.locked_mode
from v$locked_object a,
dba_objects b
where b.object_id = a.object_id;
select b.username, b.sid, b.serial
from v$locked_object a,
v$session b
where a.session_id = b.sid
order by b.logon_time;
2.杀死相关的进程
alter system kill session '2236,30987';
二.删掉所有锁的进程(谨慎使用)
declare cursor mycur is
select b.sid, b.serial
from v$locked_object a,
v$session b
where a.session_id = b.sid
group by b.sid, b.serial
begin
for cur in mycur
loop
execute immediate ('alter system kill session ''' || cur.sid || ',' || cur.SERIAL# || ''' ');
end loop;
end;