有很多KILLED的session 无法释放资源

来源：互联网发布：java登录界面图片编辑：程序博客网时间：2024/04/29 05:47

有很多KILLED的session 无法释放资源，相应的SPID也找不到，资源也没办法释放。

SID PADDR STATUS
1 9 07000000CCDF65C8 KILLED
2 12 07000000CCDF65C8 KILLED
3 16 07000000CCDF65C8 KILLED
4 23 07000000CCDF65C8 KILLED
5 24 07000000CCDF65C8 KILLED
6 25 07000000CCDF65C8 KILLED
7 28 07000000CCDF65C8 KILLED
8 40 07000000CCDF65C8 KILLED
9 61 07000000CCDF65C8 KILLED
10 62 07000000CCDF65C8 KILLED
11 71 07000000CCDF65C8 KILLED
12 78 07000000CCDF65C8 KILLED
13 81 07000000CCDF65C8 KILLED
14 86 07000000CCDF65C8 KILLED
15 97 07000000CCDF65C8 KILLED
16 104 07000000CCDF65C8 KILLED
17 108 07000000CCDF65C8 KILLED
18 109 07000000CCDF65C8 KILLED
19 112 07000000CCDF65C8 KILLED
20 126 07000000CCDF65C8 KILLED
21 133 07000000CCDF65C8 KILLED
22 136 07000000CCDF65C8 KILLED
23 137 07000000CCDF65C8 KILLED
24 141 07000000CCDF65C8 KILLED
25 150 07000000CCDF65C8 KILLED
26 152 07000000CCDF65C8 KILLED
27 170 07000000CCDF65C8 KILLED
28 171 07000000CCDF65C8 KILLED
29 172 07000000CCDF65C8 KILLED
30 183 07000000CCDF65C8 KILLED
31 186 07000000CCDF65C8 KILLED
32 189 07000000CCDF65C8 KILLED
33 190 07000000CCDF65C8 KILLED
34 191 07000000CCDF65C8 KILLED
35 201 07000000CCDF65C8 KILLED
36 202 07000000CCDF65C8 KILLED
37 203 07000000CCDF65C8 KILLED
38 206 07000000CCDF65C8 KILLED
39 207 07000000CCDF65C8 KILLED
40 209 07000000CCDF65C8 KILLED
41 210 07000000CCDF65C8 KILLED
42 211 07000000CCDF65C8 KILLED
43 215 07000000CCDF65C8 KILLED
44 216 07000000CCDF65C8 KILLED
45 220 07000000CCDF65C8 KILLED
46 225 07000000CCDF65C8 KILLED
47 228 07000000CCDF65C8 KILLED
48 230 07000000CCDF65C8 KILLED
49 231 07000000CCDF65C8 KILLED
50 238 07000000CCDF65C8 KILLED
51 239 07000000CCDF65C8 KILLED
52 240 07000000CCDF65C8 KILLED
53 242 07000000CCDF65C8 KILLED

PADDR 都已经被修改成一个固定的值07000000CCDF65C8，如何释放这种session呢？本文可以给你一点提示呵呵

对应的链接www.itpub.net/showthread.php?s=&threadid=583183&perpage=10&pagenumber=1

以为版主建议：唤醒PMON 试试

WAKEUP command（在SQL*PLUS运行的）

To wake up a process use

    ORADEBUG WAKEUP pid

For example to wake up PMON, first obtain the PID using

    SELECT pid FROM v$process
    WHERE addr = 
    (
        SELECT paddr FROM v$bgprocess
        WHERE name = 'PMON'
    );

If the PID is 2 then send a wakeup call using

    ORADEBUG WAKEUP 2
SQL> ORADEBUG WAKEUP 2
已处理的语句 
SQL> ORADEBUG WAKEUP 2
已处理的语句 
看来PMON这个后台进程正在处理资源回收，只是速度很慢而已。第二天来看还剩下6个KILLED的session。

可以用下面的sql找到相应的SPID，然后kill掉。如果是UNIX上，你要看看取出来的这些addr对应的进程，是不是后台服务进程！小心，谨慎一些！

SELECT spid,program,username
FROM v$process
WHERE addr IN (SELECT p.addr
FROM v$process p
WHERE pid <> 1
MINUS
SELECT s.paddr
FROM v$session s);

    SPID USERNAME PROGRAM SERIAL# TERMINAL
1 111594 oracle9i oracle@test1 (D000) 1 UNKNOWN
2 242328 oracle9i oracle@test1 (J003) 1 UNKNOWN
3 160686 oracle9i oracle@test1 (TNS V1-V3) 21 UNKNOWN
4 71588 oracle9i oracle@test1 (TNS V1-V3) 44 UNKNOWN
5 65748 oracle9i oracle@test1 (TNS V1-V3) 52 UNKNOWN
6 108126 oracle9i oracle@test1 (TNS V1-V3) 35 UNKNOWN
7 63306 oracle9i oracle@test1 (TNS V1-V3) 35 UNKNOWN
8 109290 oracle9i oracle@test1 (TNS V1-V3) 50 UNKNOWN