当在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——– ———- ———- ——– ———————来源gaodai#ma#com搞@代~码$网——— ——–542E0E6C11314 542D6BD4 EYGLEKILLED542E2AA414397 542D6BD4 EQSPKILLED542E504418662 542B6D38 SYSACTIVE
，
转载请注明原文链接：Oracle中的kill session的使用讲解
