关于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博客 ” ，链接：https://blog.itpub.net/21158541/viewspace-667356/ ，如需转载，请注明出处，否则将追究法律责任。
