| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:init.ora process = 50, 100, 200
Larry,
Processes is the maximum number of background processes that Oracle will spawn. These include things like DBW0, SMON,PMON, SNPx, LGWR, ARCH, dispatchers and shared servers in MTS, and dedicated servers in non MTS environments. So in a way your right, if your in a non-MTS environment then processes - 6 is the number of SQL*Net connections you can have. If your in an MTS environment then the Sessions parameter is much more important. Which by the way, for those who forgot, Sessions is a derived parameter unless set directly. The formula is 1.1*processes+5. So if processes is set to 100 then sessions can be 115. If processes is 200 sessions is 225. If processes is 50 then sessions is 60. These are pretty small in an MTS setup so one may well want to hard code it.
Dick Goulet
____________________Reply Separator____________________Subject: init.ora process = 50, 100, 200 Author: Larry Taylor <ltaylor_at_iq.com>
Hi All,
can anyone tell me exactly what is the
difference between setting the init.ora parameter
process = 100 or process = 200.
I thought that process is the max number of connections to the database at any given to via sqlnet. Is this true?
Thanks in advance
-lt
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Larry Taylor
INET: ltaylor_at_iq.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Oct 11 2000 - 16:25:52 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |