Many killed sessions cannot release resources.

Many KILLED sessions cannot release resources, the corresponding SPID cannot be found, and the resources cannot be released.

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

PADDR has been changed to a fixed value 07000000CCDF65C8. How can this session be released? This article will give you some tips.

 

Corresponding Link
Www.itpub.net/showthread.php? S = & amp; threadid = 583183 & perpage = 10 & amp; pagenumber = 1

Recommended for moderators: try to wake up PMON

WAKEUP command (run in 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
Processed statements
SQL> ORADEBUG WAKEUP 2
Processed statements
It seems that the background process of PMON is processing resource recovery, but it is only slow. The next day, we can see that there are still six KILLED sessions.

You can use the following SQL statement to find the corresponding SPID and kill it. If it is UNIX, check whether the processes corresponding to the obtained addr are backend service processes! Be careful and be cautious!

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