RE: processes vs sessions

Hmm....

If you really want to know the difference between the two initialization 
parameters, that's easy.

'sessions' defines the size (number of elements) of the session state object 
array in the SGA, whereas the 'processes' parameter defines the size of (number 
of elements in) the process state object array.  The effect is that those 
parameters define the upper bound for how many concurrent sessions and 
concurrent processes can exist, respectively.

Now, if you're really asking about the difference between a process and a 
session, Tom Kyte has an excellent explanation here:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5671284058977

Hope that helps,

-Mark

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxxxxx
www.proquest.com
www.csa.com

ProQuest...Start here. 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Mir M. Mirhashimali
Sent: Tuesday, October 30, 2007 12:45 PM
To: oracle-l
Subject: processes vs sessions

Good morning,

can somebody explain what is the difference between Processes and 
Sessions init paramaters.

Thanks

-- 
Mir M. Mirhashimali
Oracle Systems Manager
Database Architecture, Enterprise Applications
Rice University
(713) 348 6365

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: