批量kill inactive状态会话
批量kill掉inactive的会话:
SELECT SID,
SERIAL#,
INST_ID,
MODULE,
STATUS,
S.PROGRAM,
machine,
terminal,
S.LAST_CALL_ET/60/60,
'alter system disconnect session '''||sid||','||serial#||''' immediate; '
FROM v$session S WHERE S.USERNAME IS NOT NULL
-- AND UPPER(S.PROGRAM) IN ('TOAD.EXE', 'W3WP.EXE','PLSQLDEV.EXE')
AND S.LAST_CALL_ET >= 2 * 60*60
AND S.STATUS = 'INACTIVE'
ORDER BY INST_ID DESC
;

浙公网安备 33010602011771号