批量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
;

posted @ 2025-03-04 18:39  ocmji  阅读(19)  评论(0)    收藏  举报