关于SESSION与PROCESS的关系

[oracle@RHEL5 ~]$ sqlplus zxd/zxd

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 2 22:44:34 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

在会话B中，用SYS登陆的哈

SESSION A> select saddr,sid,serial#,paddr,user#,username,process,server,status from v$session where username ='ZXD';

SADDR                   SID    SERIAL# PADDR                 USER# USERNAME                       PROCESS      SERVER    STATUS
---------------- ---------- ---------- ---------------- ---------- ------------------------------ ------------ --------- --------
0000000070F65320        137        102 0000000070E63950         58 ZXD                            26606        DEDICATED INACTIVE                

SESSION A> select username,program from v$process where addr='0000000070E63950';

USERNAME        PROGRAM
--------------- ------------------------------------------------
oracle          oracle@RHEL5.4 (TNS V1-V3)

再回到刚刚的会话1

SQL> disconnect
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>

再进入会话B

SESSION A> select saddr,sid,serial#,paddr,user#,username,process,server,status from v$session where username ='ZXD';

no rows selected

SESSION A> select username,program from v$process where addr='0000000070E63950';          

USERNAME        PROGRAM
--------------- ------------------------------------------------                                                   这里说明会话没了，连接还在
oracle          oracle@RHEL5.4 (TNS V1-V3)

又一次回到会话1

SQL> exit
[oracle@RHEL5 ~]$

进入会话B

SESSION A> select saddr,sid,serial#,paddr,user#,username,process,server,status from v$session where username ='ZXD';

no rows selected

SESSION A> select username,program from v$process where addr='0000000070E63950';

no rows selected

这里说明EXIT后连接没了，会话也没了撒

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21158541/viewspace-667356/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21158541/viewspace-667356/