select t1.sid, t1.serial#, t1.username, t1.logon_time from v$session t1 , v$locked_object t2
where t1.sid = t2.session_id order by t1.logon_time
where t1.sid = t2.session_id order by t1.logon_time
查询后,分别填第1,,2个参数,就可以杀掉对应的进程。
alter system kill session '1392,24272'
alter system kill session '1392,24272'