重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: oracle 批量清理空闲会话 [打印本页]

---

作者: jiawang    时间: 2026-4-22 15:07
标题: oracle 批量清理空闲会话


先查看哪些会话可以杀
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;

登录/注册后可看大图