Sys登录主机
from v$locked_object t1, v$session t2
where t1.session_id = t2.sid
order by t2.logon_time;
执行:
select 'alter system kill session ',
'''' || trim(t2.sid) || ',' || trim(t2.serial#) || ''';'from v$locked_object t1, v$session t2
where t1.session_id = t2.sid
order by t2.logon_time;