批次KILL Oracle資料庫session，先查詢出不需要的的session（sid,serial#），然後編輯，批次執行。

SQL> spool kill_1208.sql
SQL> set pages 100000
SQL> SELECT 'ALTER SYSTEM KILL SESSION '' ' || rtrim(s.sid) || ',',ltrim(s.serial#) || ' '';'
FROM gv$session s JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE s.type != 'BACKGROUND' ;
SQL> exit
[oracle@TESTDB pump]$ cat /tmp/kill_1208.sql
ALTER SYSTEM KILL SESSION '1641, 48315 ';
ALTER SYSTEM KILL SESSION '1730, 16855 ';
ALTER SYSTEM KILL SESSION '1783, 5791 ';
ALTER SYSTEM KILL SESSION '1856, 37547 ';
ALTER SYSTEM KILL SESSION '1950, 32017 ';
ALTER SYSTEM KILL SESSION '2003, 10879 ';
ALTER SYSTEM KILL SESSION '2079, 6545 ';
ALTER SYSTEM KILL SESSION '2137, 62179 ';
ALTER SYSTEM KILL SESSION '29, 30665 ';
--去掉serial#前面的空格
sed -ri 's/,[ ]*([0-9][0-9]*)[ ]*/,\1/' kill_1208.sql
[oracle@TESTDB pump]$ sqlplus / as sysdba

SQL> @ kill_1208.sql

alter system kill session '29,30665' immediate;

Oracle kill會話--sed修改檔案

相關文章