Killed sessions

From: <vafanassiev_at_aapt.com.au>
Date: 20 Jan 2005 18:25:03 -0800
Message-ID: <1106274303.571407.3690@z14g2000cwz.googlegroups.com>

I noticed an interesting fact: if V$SESSION contains sessions with status = 'KILLED' such sessions do not appear in the join between V$PROCESS and V$SESSION.

Example:

---

SQL> select count(*) from v$session where status = 'KILLED';

COUNT(*)

---

9

SQL>
SQL> select count(*) from v$session;

COUNT(*)

---

161

SQL> select count(*) from v$process;

COUNT(*)

---

162

SQL>
SQL> select count(*)
2 from

3  	     v$session	     s,
4  	     v$process	     p
5  where
6  	     s.paddr	     = p.addr;

COUNT(*)

---

152

---

Any idea what happens? It looks like value either in V$SESSION.PADDR or V$PROCESS.ADDR changes after a session is killed. Received on Thu Jan 20 2005 - 20:25:03 CST