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
alter system kill session '615,12587'
from v$session t1, v$locked_object t2
where t1.sid = t2.session_id
order by t1.logon_time
alter system kill session '615,12587'