oracle kill session

xiaoxiao2021-03-01  13

-- 1) 查看需要KILL的进程 SELECT 'ALTER SYSTEM KILL SESSION ' || '''' || SID || ',' || SERIAL# || '''' || ' IMMEDIATE;' FROM V$SESSION WHERE USERNAME = 'DEV_MDS'; -- 2) 记住SPID // SELECT A.SID, A.SERIAL#, B.SPID, A.STATUS, A.PROGRAM FROM V$SESSION A, V$PROCESS B WHERE A.PADDR = B.ADDR AND A.SID IN (4, 83, 165, 404) ORDER BY A.SID; --- 3) KILL 进程 ALTER SYSTEM KILL SESSION '4,19955' IMMEDIATE; ALTER SYSTEM KILL SESSION '83,33095' IMMEDIATE; ALTER SYSTEM KILL SESSION '165,30253' IMMEDIATE; ALTER SYSTEM KILL SESSION '404,51628' IMMEDIATE; -- 4) 看看是否还存在 SELECT * FROM V$SESSION WHERE USERNAME = 'DEV_MDS'; -- 5) 一般KILL如上进程,若不行则需要操作系统级别KILL进程 -- 5.1) 登陆操作系统 依次 kill -9 第2)步得到的SPID进程 -- 5.2) 若上述步骤还没成功,则将下面查询到得SPID进程KILL掉。 SELECT SPID, PROGRAM FROM V$PROCESS WHERE PROGRAM != 'PSEUDO' AND ADDR NOT IN (SELECT PADDR FROM V$SESSION) AND ADDR NOT IN (SELECT PADDR FROM V$BGPROCESS);
转载请注明原文地址: https://www.6miu.com/read-3350237.html

最新回复(0)