| 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
Dick,
So could you gave me an example of an MTS environment of lets say, I expect about 3000 hits against the database. What would be a a good MTS parameter setting.
Thanks again.
lt
-----Original Message-----
From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
Sent: Wednesday, October 11, 2000 3:32 PM
To: Multiple recipients of list ORACLE-L
Subject: 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____________________ Author: Larry Taylor <ltaylor_at_iq.com> Date: 10/11/00 12:17 PM
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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
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 Received on Wed Oct 11 2000 - 17:46:49 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |