Message-Id: <10676.121803@fatcity.com> From: "Rajendran, Srini" Date: Fri, 10 Nov 2000 16:28:46 -0500 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_01C04B5D.35169CD0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit 'olninfo_us@oracle.com' -----Original Message----- From: Satar Naghshineh [mailto:Satar.Naghshineh@irvine.mellesgriot.com] Sent: Friday, November 10, 2000 4:11 PM To: Multiple recipients of list ORACLE-L Subject: 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 -----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_01C04B5D.35169CD0 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable RE: init.ora PROCESS parameter

'olninfo_us@oracle.com'

-----Original Message-----
From: Satar Naghshineh=20 [mailto:Satar.Naghshineh@irvine.mellesgriot.com]
Sent: = Friday,=20 November 10, 2000 4:11 PM
To: Multiple recipients of list=20 ORACLE-L
Subject: RE: init.ora PROCESS=20 parameter

Larry,

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

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

Regards,
Satar

    -----Original Message----- =
    From:       Larry=20 Taylor [SMTP:ltaylor@iq.com]
    Sent:   Friday, November=20 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=20 parameter in the init.ora file
    affect the=20 performance of the database. I can't seem to find any good =
    information
    in the=20 8.1.6 documentation.

    Database is MTS configured. =

    My 8.1.6 database init.ora has the = following=20 options:

    #processes =3D=20 = 50           &nbs= p;           &nbs= p;           &nbs= p;           &nbs= p;       =20 #
    SMALL
    # processes =3D=20 = 100           &nb= sp;           &nb= sp;           &nb= sp;           &nb= sp;    =20 #
    MEDIUM
    #processes =3D=20 = 200           &nb= sp;           &nb= sp;           &nb= sp;           &nb= sp;    =20 # LARGE

    processes  =3D 800

    What I have noticed is that, my = database will not=20 startup if the process
    value = is=20 greater
    than 800. =

    Thanks for any help you can = provide.=20
    larry

    --
    Please see=20 the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Larry = Taylor=20
      INET: ltaylor@iq.com =

    Fat City Network = Services    --=20 (858) 538-5051  FAX: (858) 538-5051
    San Diego, = California        --=20 Public Internet access / Mailing Lists
    ---------------------------------------------------------------= -----=20
    To REMOVE yourself from this = mailing list, send=20 an E-Mail message
    to:=20 ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and = in=20
    the message BODY, include a line = containing:=20 UNSUB ORACLE-L
    (or the name = of mailing=20 list you want to be removed from).  You may