查看会话对应的系统进程
SELECT SID,SERIAL#,PROCESS,LOGON_TIME,USERNAME,PROGRAM,status,''''||sid||','||serial#||''''
FROM V$SESSION
ORDER BY LOGON_TIME DESC
结束会话
批量生成kill语句
SELECT
'alter system kill session ''' || sid || ',' || serial # || ''';'
FROM
V$SESSION
WHERE
username = upper( 'system' )
AND OSUSER = 'MINI';