欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

Oracle中的connection,session及process的区别 oracleconnectionsessionprocess 

程序员文章站 2022-07-13 13:38:22
...
Oracle's connection and session and process
1.process:connection断了,process也可以存在
2.session:仅当你connection时,才会保持session.
3.connection:"physical circuit",1个connection对应0个或者1个或者多个session
A connection is a physical circuit between you and the database. A connection might be
one of many types -- most popular begin DEDICATED server and SHARED server. Zero, one or
more sessions may be established over a given connection to the database as show above
with sqlplus. A process will be used by a session to execute statements. Sometimes
there is a one to one relationship between CONNECTION->SESSION->PROCESS (eg: a normal
dedicated server connection). Sometimes there is a one to many from connection to
sessions (eg: like autotrace, one connection, two sessions, one process). A process does
not have to be dedicated to a specific connection or session however, for example when
using shared server (MTS), your SESSION will grab a process from a pool of processes in
order to execute a statement. When the call is over, that process is released back to
the pool of processes.

可以参见asktom:asktom.oracle.com/pls/asktom/f

编写于【2009-01-15】