当在oracle中kill session以后, oracle只是简单的把相关session的paddr 指向同一个虚拟地址.此时v$process和v$session失去关联,进
sql> select saddr,sid,serial#,paddr,username,status from v$session where username is not null;saddrsid serial# paddr usernamestatus-------- ---------- ---------- -------- ------------------------------ --------542e0e6c11314 542b70e8 eygleinactive542e504418662 542b6d38 sysactivesql> alter system kill session '11,314';system altered.sql> select saddr,sid,serial#,paddr,username,status from v$session where username is not null;saddrsid serial# paddr usernamestatus-------- ---------- ---------- -------- ------------------------------ --------542e0e6c11314 542d6bd4 eyglekilled542e504418662 542b6d38 sysactivesql> select saddr,sid,serial#,paddr,username,status from v$session where username is not null;saddrsid serial# paddr usernamestatus-------- ---------- ---------- -------- ------------------------------ --------542e0e6c11314 542d6bd4 eyglekilled542e2aa414397 542b7498 eqspinactive542e504418662 542b6d38 sysactivesql> alter system kill session '14,397';system altered.sql> select saddr,sid,serial#,paddr,username,status from v$session where username is not null;saddrsid serial# paddr usernamestatus-------- ---------- ---------- -------- ------------------------------ --------542e0e6c11314 542d6bd4 eyglekilled542e2aa414397 542d6bd4 eqspkilled542e504418662 542b6d38 sysactive
，