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
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博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-978814/，如需转载，请注明出处，否则将追究法律责任。