RE: init.ora process = 50, 100, 200

From: Larry Taylor <ltaylor_at_iq.com>
Date: Wed, 11 Oct 2000 15:46:49 -0700
Message-Id: <10646.119025@fatcity.com>

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.

-----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 Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: 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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message