Re: What is difference between processes and sessions?

From: <yong321_at_yahoo.com>
Date: Thu, 20 Jan 2000 15:59:26 GMT
Message-ID: <867bcj$7l9$1@nnrp1.deja.com>

In article <01bf6273$29d5c5e0$3601017e_at_EHM.cirra.fr>, "Emmanuel" <zouzou_at_yahoo.com> wrote:
> Moreover, each time a user connects hence starts a new session, a new
> process is created. A session can be therefore considered as a
particular
> type of process.

>
> oraclexxxx
>
> are the session processes.

Not on NT. NT has one process handling all user connections (sessions). Those sessions create threads in the ORACLE.EXE process. Launch Task Manager and add the columns Threads (and Handles if you're interested in that too) to the view. Watch the row for ORACLE80.EXE (my Oracle is 8.0.5). Make a sqlplus connection, and you'll see the Threads value jump by 1 (and Handles increases by 6, 8 or some other number).

--
Yong Huang

(yong321_at_yahoo.com)
(http://www.stormloader.com/yonghuang/)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 20 2000 - 09:59:26 CST