原始链接:
A databaseconnectionis a physical communication pathway between a client process and a database instance.
一个数据库的连接是在客户端进程和数据库实例中的一个物理连接.
During a connection, a communication pathway is established using available interprocess communication mechanisms or network software. Typically, a connection occurs between a client process and a server process or dispatcher, but it can also occur between a client process and Oracle Connection Manager (CMAN).
在连接过程中,使用内部进程通信方法或者网络软件来建立通道.通常来说.一个连接是建立在一个客户端进程和一个服务器端进程或者是一个分发器中,但是它可也可以存在在一个客户端和Oracle连接管理器中.
A database is a logical entity in the database instance memory that represents the state of a current user login to a database. For example, when a user is authenticated by the database with a password, a session is established for this user. A session lasts from the time the user is authenticated by the database until the time the user disconnects or exits the database application.
一个数据库进程是一个逻辑上的概念它代表一个用户连接数据库的状态.举例来说,当一个用户被数据库授权后,一个针对这个用户的进程被建立并且这个进程会持续到这个用户的链接断开或者退出数据库
A single connection can have 0, 1, or more sessions established on it. The sessions are independent: a commit in one session does not affect transactions in other sessions.
一个独立的链接会有超过一个进程存在.并且进程是互相独立的.在一个进程中的提交并不会影响其他进程的事物.
Note:
If Oracle Net is configured, then it is possible for a connection to drop but leave the sessions intact.
如果Oracle网络服务中配置的连接池,那么会
Multiple sessions can exist concurrently for a single database user. As shown in the following figure, user hr can have multiple connections to a database. In dedicated server connections, the database creates a server process on behalf of each connection. Only the client process that causes the dedicated server to be created uses it. In a shared server connection, many client processes access a single shared server process.
多个进程可以同时存在在一个数据库用户中.就如下面的例子,用户HR能够建立多个连接 ,在一个专用服务器连接方式中,数据库为每一个连接建立一个服务器进程.只有那些使用专用服务器建立的客户端进程能够使用这个服务器进程.在一个共享服务器准哦概念,多个客户算进程可以共用一个服务器进程
一个connection对应一个session
一个connection对应多个session