首页 > 应用开发 > IT综合 > Connections and Sessions (110)

Connections and Sessions (110)

原创 IT综合 作者:tsinglee 时间:2007-10-27 15:35:59 0 删除 编辑

Connection and session are closely related to user process but are very different in


A connection is a communication pathway between a user process and an Oracle

instance. A communication pathway is established using available interprocess

communication mechanisms (on a computer that runs both the user process and

Oracle) or network software (when different computers run the database application

and Oracle, and communicate through a network).

A session is a specific connection of a user to an Oracle instance through a user

process. For example, when a user starts SQL*Plus, the user must provide a valid user

name and password, and then a session is established for that user. A session lasts

from the time the user connects until the time the user disconnects or exits the

database application.

Multiple sessions can be created and exist concurrently for a single Oracle user using

the same user name. For example, a user with the user name/password of

SCOTT/TIGER can connect to the same Oracle instance several times.

In configurations without the shared server, Oracle creates a server process on behalf

of each user session. However, with the shared server, many user sessions can share a

single server process.

1. 连接是指用户进程与Oracle实例的通信途径 , 使用可利用的进程间的通信机制或者网络软件来建立.

2. 会话是指用户和实例之间通过用户进程的一个连接 , 会话的生命周期从用户连接开始至用户退出连接或者退出应用程序结束[@more@]

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
  • 博文量
  • 访问量