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_at_il.proquest.com
www.proquest.com
www.csa.com

ProQuest...Start here.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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 Received on Tue Oct 30 2007 - 13:01:07 CDT