Connections and Sessions【1008】

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

meaning.

对于用户进程来说，连接和会话是相近相关的但是在意义上却不相同。

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).

对于用户进程和一个数据库实例来说，一个连接是一个通信通道。一个通信通道创建

使用可用的进程间的通信机制（在一个同时运行用户进程和ORACLE的电脑上）或者

网络软件(当不同的电脑运行数据库应用和数据库，并且通过网络通信）

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.

一个会话是一个特定的用户连接对于一个用户进程连接到ORACLE实例。比如当一个用户

启动SQL*PLUS，用户必须提供一个可用的用户名和密码，然后一个会话创建给这个用户，

一个会话持续的时间从用户的连接直到用户的断开或者是退出数据库应用。

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.

多个用户可以被创建和并行存在的对于一个单独的ORACLE用户使用相同的用户名。比如，比如

一个用户使用SCOTT/TIGER的用户名和密码可能连接到同一个数据库多次。

在非共享服务的配置上，ORACLE创建一个服务进程与每一个用户会话。但是，在共享服务模式下

多个用户可共享一个单独的服务进程。