oracle 批量清理空闲会话

jiawang

先查看哪些会话可以杀
SELECT
  sid,
  serial#,
  username,
  machine,
  program,
  status,
  TO_CHAR(logon_time, 'yyyy-mm-dd hh24:mi:ss') AS logon_time,
  ROUND(last_call_et / 3600, 2) AS idle_hours,
  sql_id,
  prev_sql_id
FROM v$session
WHERE
  TYPE='USER'
  AND username IS NOT NULL
  AND status='INACTIVE'
  AND last_call_et > 3600  -- 空闲>1小时
ORDER BY last_call_et DESC;

登录/注册后可看大图