| 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_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_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.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_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_01C04B57.EAC7B680
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =charset=3DUS-ASCII">
<TITLE>RE: init.ora PROCESS parameter</TITLE> </HEAD> <BODY>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Larry,</FONT> </P>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">What OS? Your = process parameter and your shmmni (in UNIX) should be the same.</FONT> </P>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">The affect it will =
have on your system is that it will allocate the proper memory in the =
OS.</FONT>
<BR>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Regards,<BR>
Satar</FONT>
</P> <UL> <P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT> <BR><B><FONT SIZE=3D1 FACE=3D"Arial">From: </FONT></B> <FONT =SIZE=3D1 FACE=3D"Arial">Larry Taylor [SMTP:ltaylor_at_iq.com]</FONT> <BR><B><FONT SIZE=3D1 FACE=3D"Arial">Sent: </FONT></B> <FONT = SIZE=3D1 FACE=3D"Arial">Friday, November 10, 2000 7:11 PM</FONT> <BR><B><FONT SIZE=3D1 =
<P><FONT SIZE=3D2 FACE=3D"Arial">Hi All,</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Can anyone tell me, how does the = PROCESS parameter in the init.ora file</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">affect the performance of the = database. I can't seem to find any good</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">information</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">in the 8.1.6 documentation.</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Database is MTS configured.</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial">My 8.1.6 database init.ora has the =
following options:</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">#processes =3D =
50 &nbs= p; &nbs= p; &nbs= p; &nbs= p; #</FONT><BR><FONT SIZE=3D2 FACE=3D"Arial">SMALL</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial"># processes =3D =
100 &nb= sp; &nb= sp; &nb= sp; &nb= sp; #</FONT>
200 &nb= sp; &nb= sp; &nb= sp; &nb= sp; # LARGE</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">processes =3D 800</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial">What I have noticed is that, my = database will not startup if the process</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">value is greater</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">than 800.</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks for any help you can =
provide.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">larry</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L =
FAQ:</FONT><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT></U>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Larry Taylor</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial"> INET: ltaylor_at_iq.com</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Fat City Network =
Services -- (858) 538-5051 FAX: (858) =
538-5051</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">San Diego, =
California -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">---------------------------------------------------------=-----------</FONT>
 |
 |