Oracle中的connection,session及process的区别

最新推荐文章于 2023-03-01 11:10:15 发布

can_do_it

最新推荐文章于 2023-03-01 11:10:15 发布

阅读量314

点赞数

CC 4.0 BY-SA版权

文章标签： oracle connection session process

本文链接：https://blog.youkuaiyun.com/can_do_it/article/details/84794403

本文探讨了Oracle数据库中连接(connection)、会话(session)及进程(process)的关系。阐述了一个连接可以对应零个、一个或多个会话，而一个进程用于执行会话中的语句。在共享服务器模式下，会话从进程池中获取进程执行语句。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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】