| 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 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_at_oracle.com' <mailto:'olninfo_us_at_oracle.com'>
-----Original Message-----
From: Satar Naghshineh [mailto:Satar.Naghshineh_at_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_at_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.orafile
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 theprocess
Thanks for any help you can provide.
larry
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<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).
------_=_NextPart_001_01C04B5D.35169CD0
Content-Type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>RE: init.ora PROCESS parameter</TITLE>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2>
<P><B><FONT face=3DArial size=3D1><A=20
href=3D"mailto:'olninfo_us_at_oracle.com'">'olninfo_us_at_oracle.com'</A></FON=
T></B></P></FONT></DIV>
<BLOCKQUOTE>
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Satar Naghshineh=20
[mailto:Satar.Naghshineh_at_irvine.mellesgriot.com]<BR><B>Sent:</B> =
Friday,=20
November 10, 2000 4:11 PM<BR><B>To:</B> Multiple recipients of list=20
ORACLE-L<BR><B>Subject:</B> RE: init.ora PROCESS=20
parameter<BR><BR></DIV></FONT>
<P><FONT color=3D#0000ff face=3DArial size=3D2>Larry,</FONT> </P>
<P><FONT color=3D#0000ff face=3DArial size=3D2>What OS? Your =
process parameter=20
and your shmmni (in UNIX) should be the same.</FONT> </P>
<P><FONT color=3D#0000ff face=3DArial size=3D2>The affect it will =
have on your=20
system is that it will allocate the proper memory in the OS.</FONT>=20
<BR><BR><FONT color=3D#0000ff face=3DArial =
size=3D2>Regards,<BR>Satar</FONT> </P>
<UL>
<P><FONT face=3DArial size=3D1>-----Original Message-----</FONT> =
<BR><B><FONT=20
face=3DArial size=3D1>From: </FONT></B> <FONT =
face=3DArial size=3D1>Larry=20
Taylor [SMTP:ltaylor_at_iq.com]</FONT> <BR><B><FONT face=3DArial=20
size=3D1>Sent: </FONT></B> <FONT face=3DArial =
size=3D1>Friday, November=20
10, 2000 7:11 PM</FONT> <BR><B><FONT face=3DArial=20
size=3D1>To: </FONT></B> <FONT face=3DArial=20
size=3D1>Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT =
face=3DArial=20
=
size=3D1>Subject: </FONT></B> =
<FONT=20
face=3DArial size=3D1>init.ora PROCESS parameter</FONT> </P>
<P><FONT face=3DArial size=3D2>Hi All,</FONT> </P>
<P><FONT face=3DArial size=3D2>Can anyone tell me, how does the =
PROCESS=20
parameter in the init.ora file</FONT> <BR><FONT face=3DArial =
size=3D2>affect the=20
performance of the database. I can't seem to find any good</FONT> =
<BR><FONT=20
face=3DArial size=3D2>information</FONT> <BR><FONT face=3DArial =
size=3D2>in the=20
8.1.6 documentation.</FONT> </P>
<P><FONT face=3DArial size=3D2>Database is MTS configured.</FONT> =
</P>
<P><FONT face=3DArial size=3D2>My 8.1.6 database init.ora has the =
following=20
options:</FONT> </P>
<P><FONT face=3DArial size=3D2>#processes =3D=20
=
50 &nbs=
p; &nbs=
p; &nbs=
p; &nbs=
p; =20
#</FONT> <BR><FONT face=3DArial size=3D2>SMALL</FONT> <BR><FONT =
face=3DArial=20
size=3D2># processes =3D=20
=
100 &nb=
sp; &nb=
sp; &nb=
sp; &nb=
sp; =20
#</FONT> <BR><FONT face=3DArial size=3D2>MEDIUM</FONT> <BR><FONT =
face=3DArial=20
size=3D2>#processes =3D=20
=
200 &nb=
sp; &nb=
sp; &nb=
sp; &nb=
sp; =20
# LARGE</FONT> </P>
<P><FONT face=3DArial size=3D2>processes =3D 800</FONT> </P>
<P><FONT face=3DArial size=3D2>What I have noticed is that, my =
database will not=20
startup if the process</FONT> <BR><FONT face=3DArial size=3D2>value =
is=20
greater</FONT> <BR><FONT face=3DArial size=3D2>than 800.</FONT> =
</P>
<P><FONT face=3DArial size=3D2>Thanks for any help you can =
provide.</FONT>=20
<BR><FONT face=3DArial size=3D2>larry</FONT> </P>
<P><FONT face=3DArial size=3D2>-- </FONT><BR><FONT face=3DArial =
size=3D2>Please see=20
the official ORACLE-L FAQ:</FONT><U> <FONT color=3D#0000ff =
face=3DArial=20
size=3D2><A href=3D"http://www.orafaq.com"=20
target=3D_blank>http://www.orafaq.com</A></FONT></U> <BR><FONT =
face=3DArial=20
size=3D2>-- </FONT><BR><FONT face=3DArial size=3D2>Author: Larry =
Taylor</FONT>=20
<BR><FONT face=3DArial size=3D2> INET: ltaylor_at_iq.com</FONT> =
</P>
<P><FONT face=3DArial size=3D2>Fat City Network =
Services --=20
(858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT =
face=3DArial=20
size=3D2>San Diego, =
California --=20
Public Internet access / Mailing Lists</FONT> <BR><FONT =
face=3DArial=20
=
size=3D2>---------------------------------------------------------------=
-----</FONT>=20
<BR><FONT face=3DArial size=3D2>To REMOVE yourself from this =
mailing list, send=20
an E-Mail message</FONT> <BR><FONT face=3DArial size=3D2>to:=20
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and =
in</FONT>=20
<BR><FONT face=3DArial size=3D2>the message BODY, include a line =
containing:=20
UNSUB ORACLE-L</FONT> <BR><FONT face=3DArial size=3D2>(or the name =
of mailing=20
list you want to be removed from). You may</FONT> <BR><FONT =
Received on Fri Nov 10 2000 - 15:28:46 CST
 |
 |