oracle查杀会话进程

查看会话对应的系统进程

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';