ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Differences between connection, session and process

Differences between connection, session and process

原创 Linux操作系统 作者:hock57 时间:2010-07-06 22:40:14 0 删除 编辑

#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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2010-07-06

  • 博文量
    4
  • 访问量
    7707