Oralce 解决表死锁，杀死回话进程

1、查看死锁的回话

select b.username,b.sid,b.serial#,logon_time 
from v$locked_object a,v$session b
where a.session_id = b.sid order by b.logon_time;

2、杀死回话

alter system kill session 'sid,serial#';

-- alter system kill session '29,5497';

3、批量杀死回话

declare cursor lockcur 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 lockcur
    loop  
     execute immediate ( 'alter system  kill session  '''||cur.sid || ','|| cur.SERIAL# ||''' ');
     end loop;
 
end;