首先运行如下代码:
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
执行完了记住sid和serial#
再执行下面的语句:
alter system kill session 'sid,serial#'
其中sid和serial#分别为第一个语句查出的结果里面的数值