Differences between connection, session and process

#In Linux oracle server  instance: denver
[oracle@oracle9i ~]$ ps -ef | grep oracledenver
oracle   21013 20864  0 07:25 pts/0    00:00:00 grep oracledenver
no process, no anything

#In windows command
C:\>sqlplus sys/oracle@oracle9i as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on 星期二 7月 6 22:19:34 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

连接到:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

#In Linux oracle server
[oracle@oracle9i ~]$ ps -ef | grep oracledenver
oracle   21017     1  0 07:27 ?        00:00:00 oracledenver (LOCAL=NO)
oracle   21021 20864  0 07:28 pts/0    00:00:00 grep oracledenver
server established a process 21017

#In windows command
SQL> select * from dual;

DU
--
X
session activity

SQL> disconnect
从 Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production 断开
session disconnected

SQL> select * from dual;
SP2-0640: 未连接
can not retrive data from database

#In Linux oracle server
[oracle@oracle9i ~]$ ps -ef | grep oracledenver
oracle   21017     1  0 07:27 ?        00:00:00 oracledenver (LOCAL=NO)
oracle   21030 20864  0 07:34 pts/0    00:00:00 grep oracledenver
the process still alive, and then connect still established but have not a session.

#In windows command
SQL> quit

C:\>
quit in SQL prompt, retrun to cmd window

#In Linux oracle server
[oracle@oracle9i ~]$ ps -ef | grep oracledenver
oracle   21035 20864  0 07:37 pts/0    00:00:00 grep oracledenver
the process disappered, and the connection is cut

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

转载于:http://blog.itpub.net/16817148/viewspace-667385/