http://www.searchman.info/tips/1680.html
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#》';
http://www.searchman.info/tips/1680.html
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#》';