oracle快速查杀阻塞的会话进程

适用rac环境：查阻塞的会话

select *
  from (select a.inst_id, a.sid, a.serial#,
               a.sql_id,
               a.event,
               a.status,
               connect_by_isleaf as isleaf,
               sys_connect_by_path(a.SID||'@'||a.inst_id, ' <- ') tree,
               level as tree_level
          from gv$session a
         start with a.blocking_session is not null
        connect by (a.sid||'@'||a.inst_id) = prior (a.blocking_session||'@'||a.blocking_instance))
 where isleaf = 1
 order by tree_level asc;

杀会话：

alter system kill session 'sid,serial,@sid' immediate;

如果数据库层面无法kill，那么可在操作系统层面根据spid杀进程释放：

select c.spid from v$process c where c.addr=(select b.paddr from v$session b where b.sid=496);

其它查杀方式：
https://www.modb.pro/db/623536

相关参考：
https://blog.csdn.net/jycjyc/article/details/121117037
https://www.cnblogs.com/jyzhao/p/8716546.html