SELECT 'alter system kill session '''|| SE.sid||',' ||SE.serial#||''';',
SE.sid,
SE.serial#,
PR.spid,
SE.status,
SUBSTR(SE.program, 1, 20) PROG,
SUBSTR(SE.machine, 1, 30) MACH,
SQ.sql_text
FROM v$session SE, v$sqlarea SQ, v$process PR
WHERE SE.paddr = PR.ADDR(+)
AND SE.sql_address = SQ.address(+)
AND schemaname <> 'SYS'
ORDER BY SE.sid;
版權聲明:本文為CSDN部落客「weixin_34293059」的原創文章,遵循CC 4.0 BY-SA版權協定,轉載請附上原文出處連結及本聲明。
原文連結:https://blog.csdn.net/weixin_34293059/article/details/92120475