2014-04-02から1日間の記事一覧
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#》';