Connections and Sessions (110)

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

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@]