【Oracle】强制关闭会话

select sid, serial# from V$session
where sid in (select sid from v$LOCK where TYPE in ('TM','TX'));
alter system kill session 'sid, serial#';

原文地址:https://www.cnblogs.com/sekihin/p/5033360.html