Message-Id: <10676.121796@fatcity.com> From: Satar Naghshineh Date: Fri, 10 Nov 2000 12:50:53 -0800 Subject: RE: init.ora PROCESS parameter This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C04B57.EAC7B680 Content-Type: text/plain Larry, What OS? Your process parameter and your shmmni (in UNIX) should be the same. The affect it will have on your system is that it will allocate the proper memory in the OS. Regards, Satar > -----Original Message----- > From: Larry Taylor [SMTP:ltaylor@iq.com] > Sent: Friday, November 10, 2000 7:11 PM > To: Multiple recipients of list ORACLE-L > Subject: init.ora PROCESS parameter > > Hi All, > > Can anyone tell me, how does the PROCESS parameter in the init.ora file > affect the performance of the database. I can't seem to find any good > information > in the 8.1.6 documentation. > > Database is MTS configured. > > My 8.1.6 database init.ora has the following options: > > #processes = 50 # > SMALL > # processes = 100 # > MEDIUM > #processes = 200 # > LARGE > > processes = 800 > > What I have noticed is that, my database will not startup if the process > value is greater > than 800. > > Thanks for any help you can provide. > larry > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Larry Taylor > INET: ltaylor@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@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). ------_=_NextPart_001_01C04B57.EAC7B680 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: init.ora PROCESS parameter

Larry,

What OS?  Your = process parameter and your shmmni (in UNIX) should be the same.

The affect it will = have on your system is that it will allocate the proper memory in the = OS.

Regards,
Satar