RE: processes vs sessions
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <mhyder@xxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 30 Oct 2007 14:01:07 -0400
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
