KIll session 脚本

kill超过1天未active的session

SELECT 'ALTER SYSTEM KILL SESSION ''' || s.sid || ',' || s.serial# || ''';',
       'kill -9 ' || p.SPID
  FROM v$session s, v$process p
 WHERE s.username IS NOT NULL
   and s.PADDR = p.ADDR
   AND s.status != 'ACTIVE'
   and s.last_call_et > '86400'
 ORDER BY s.last_call_et;