SELECT s.username, s.status,s.machine,s.osuser,spid,
'kill -9 '||spid,
'alter system kill session ' ||''''||s.sid||','||s.serial# || ''';',
TO_CHAR (logon_time, 'dd/mm/yyyy hh24:mi:ss'),
last_call_et,
TO_CHAR (TRUNC (last_call_et / 3600, 0))||' '||' HRS '||
TO_CHAR (TRUNC ((last_call_et - TRUNC(last_call_et / 3600, 0) * 3600) / 60, 0) ) ||' MINS',
module
FROM v$session s, v$process p
WHERE TYPE = 'USER'
AND p.addr = s.paddr
AND status != 'KILLED'
AND last_call_et >60
ORDER BY last_call_et desc;
'kill -9 '||spid,
'alter system kill session ' ||''''||s.sid||','||s.serial# || ''';',
TO_CHAR (logon_time, 'dd/mm/yyyy hh24:mi:ss'),
last_call_et,
TO_CHAR (TRUNC (last_call_et / 3600, 0))||' '||' HRS '||
TO_CHAR (TRUNC ((last_call_et - TRUNC(last_call_et / 3600, 0) * 3600) / 60, 0) ) ||' MINS',
module
FROM v$session s, v$process p
WHERE TYPE = 'USER'
AND p.addr = s.paddr
AND status != 'KILLED'
AND last_call_et >60
ORDER BY last_call_et desc;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31448824/viewspace-2136605/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Oracle查看日志切换时间
下一篇：
查询一个月以来表空间的变化情况
请登录后发表评论
登录
全部评论
