2、SELECT sid, serial#, username, osuser FROM v$session where sid = 162; 将162换成你查出来的session_id
3、kill掉session
ALTER SYSTEM KILL SESSION ‘162,4294‘; 4294为第二步查出来的serial#;
转自 http://www.cnblogs.com/yuxiaona/p/5862021.html
原文：http://www.cnblogs.com/cmyxn/p/5906793.html