Re: process and session

cho5 wrote:
>
> what is the differenece between process and session? When you set up your
> initial control file, the number of process has anything to do with
> LICENSE_MAX_SESSION. Those two numbers must be the same number or
An Oracle "process" is basically a thread of execution of the "oracle" executable program -- on a UNIX box each Oracle process will be a separate OS-level process, while on NT it will be a separate thread within the (mutithreaded) oracle executable (eg., Oracle73.exe). A session is a client-level connection to the database opened with an Oracle username & password & typically used to excecute SQL statements. When you start up an Oracle instance you will typically have at least (5) processes, before any users have connected: 4 "background" processes such as PMON & a process called "PSEUDO". LICENSE_MAX_SESSION applies to concurrent sessions & not to processes per se (though each session *may* require a new process, depending upon how the database is configured.)

Hope this helps

Received on Mon May 03 1999 - 16:11:56 CDT