| 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_01C04B51.CA254C10
Content-Type: text/plain;
charset="iso-8859-1"
Thank you very much Lisa, you are a great asset to this list.
Larry
-----Original Message-----
From: Koivu, Lisa [mailto:lkoivu_at_qode.com]
Sent: Friday, November 10, 2000 11:31 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: init.ora PROCESS parameter
Hi Larry,
This number is directly affected by the number of semaphores available on your system. When you start up a database, it checks to see if there is at least the number of sems available as the number of max processes you are defining. If there isn't, it won't start. If you have other databases on the same host, be sure your total # of sems is greater than the sum of all the processes parms defined in all your init.ora's.
As far as performance metrics... I can't speak to that, except, well do you really want 800 concurrent connections to your database??? If I ever get to that point I am going to implement MTS because it's going to be a nightmare when it does happen. I simply don't have the resources to support that kind of workload. Yet.
HTH...
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849
"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."
-----Original Message-----
From: Larry Taylor [ mailto:ltaylor_at_iq.com <mailto:ltaylor_at_iq.com> ]
Sent: Friday, November 10, 2000 2: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.comReceived on Fri Nov 10 2000 - 14:07:02 CST
<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_01C04B51.CA254C10 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.50.4134.600" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D793110820-10112000><FONT face=3DArial =
color=3D#0000ff size=3D2>Thank=20 you very much Lisa, you are a great asset to this = list.</FONT></SPAN></DIV>
<DIV><SPAN class=3D793110820-10112000><FONT face=3DArial =
color=3D#0000ff=20 size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D793110820-10112000><FONT face=3DArial =
color=3D#0000ff=20 size=3D2>Larry</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT = face=3DTahoma=20 size=3D2>-----Original Message-----<BR><B>From:</B> Koivu, Lisa=20 [mailto:lkoivu_at_qode.com]<BR><B>Sent:</B> Friday, November 10, 2000 = 11:31=20 AM<BR><B>To:</B> Multiple recipients of list = ORACLE-L<BR><B>Subject:</B> RE:=20 init.ora PROCESS parameter<BR><BR></FONT></DIV> <P><FONT size=3D2>Hi Larry, </FONT></P> <P><FONT size=3D2>This number is directly affected by the number of = semaphores=20 available on your system. When you start up a database, it = checks to see=20 if there is at least the number of sems available as the number of = max=20 processes you are defining. If there isn't, it won't = start. If you=20 have other databases on the same host, be sure your total # of sems = is greater=20 than the sum of all the processes parms defined in all your=20 init.ora's.</FONT></P> <P><FONT size=3D2>As far as performance metrics... I can't = speak to that,=20 except, well do you really want 800 concurrent connections to your = database???=20 If I ever get to that point I am going to implement MTS because it's = going to=20 be a nightmare when it does happen. I simply don't have the = resources to=20 support that kind of workload. Yet.</FONT></P> <P><FONT size=3D2>HTH...</FONT> </P> <P><FONT size=3D2>Lisa Rutland Koivu</FONT> <BR><FONT size=3D2>Oracle = Database=20 Administrator</FONT> <BR><FONT size=3D2>Qode.com</FONT> <BR><FONT = size=3D2>4850=20 North State Road 7</FONT> <BR><FONT size=3D2>Suite G104</FONT> =
<BR><FONT=20
size=3D2>Fort Lauderdale, FL 33319</FONT> </P> <P><FONT size=3D2>V: 954.484.3191, x174</FONT> <BR><FONT size=3D2>F: = 954.484.2933=20 </FONT><BR><FONT size=3D2>C: 954.658.5849</FONT> <BR><FONT = size=3D2><A=20 target=3D_blank = href=3D"http://www.qode.com">http://www.qode.com</A></FONT> </P> <P><FONT size=3D2>"The information contained herein does not express = the opinion=20 or position of Qode.com and cannot be attributed to or made binding = upon=20 Qode.com."</FONT></P><BR> <P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT = size=3D2>From: Larry=20 Taylor [<A = href=3D"mailto:ltaylor_at_iq.com">mailto:ltaylor_at_iq.com</A>]</FONT>=20 <BR><FONT size=3D2>Sent: Friday, November 10, 2000 2:11 PM</FONT> =
<BR><FONT=20
size=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT=20 size=3D2>Subject: init.ora PROCESS parameter</FONT> </P><BR> <P><FONT size=3D2>Hi All,</FONT> </P> <P><FONT size=3D2>Can anyone tell me, how does the PROCESS parameter = in the=20 init.ora file</FONT> <BR><FONT size=3D2>affect the performance of the = database.=20 I can't seem to find any good</FONT> <BR><FONT = size=3D2>information</FONT>=20 <BR><FONT size=3D2>in the 8.1.6 documentation.</FONT> </P> <P><FONT size=3D2>Database is MTS configured.</FONT> </P> <P><FONT size=3D2>My 8.1.6 database init.ora has the following = options:</FONT>=20 </P> <P><FONT size=3D2>#processes =3D=20 = 50 &nbs= p; &nbs= p; &nbs= p; &nbs= p; =20 #</FONT> <BR><FONT size=3D2>SMALL</FONT> <BR><FONT size=3D2># = processes =3D=20 = 100 &nb= sp; &nb= sp; &nb= sp; &nb= sp; =20 #</FONT> <BR><FONT size=3D2>MEDIUM</FONT> <BR><FONT = size=3D2>#processes =3D=20 = 200 &nb= sp; &nb= sp; &nb= sp; &nb= sp; =20 # LARGE</FONT> </P> <P><FONT size=3D2>processes =3D 800</FONT> </P> <P><FONT size=3D2>What I have noticed is that, my database will not = startup if=20 the process</FONT> <BR><FONT size=3D2>value is greater</FONT> =
<BR><FONT=20
size=3D2>than 800.</FONT> </P> <P><FONT size=3D2>Thanks for any help you can provide.</FONT> =
<BR><FONT=20
size=3D2>larry</FONT> </P> <P><FONT size=3D2>-- </FONT><BR><FONT size=3D2>Please see the = official ORACLE-L=20 FAQ: <A target=3D_blank=20 href=3D"http://www.orafaq.com">http://www.orafaq.com</A></FONT> =
<BR><FONT=20
size=3D2>-- </FONT><BR><FONT size=3D2>Author: Larry Taylor</FONT> =
<BR><FONT=20
size=3D2> INET: ltaylor_at_iq.com</FONT> </P> <P><FONT size=3D2>Fat City Network Services -- = (858)=20 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT size=3D2>San = Diego,=20 California -- Public = Internet access=20 / Mailing Lists</FONT> <BR><FONT=20 = size=3D2>---------------------------------------------------------------= -----</FONT>=20 <BR><FONT size=3D2>To REMOVE yourself from this mailing list, send an = E-Mail=20 message</FONT> <BR><FONT size=3D2>to: ListGuru_at_fatcity.com (note = EXACT spelling=20 of 'ListGuru') and in</FONT> <BR><FONT size=3D2>the message BODY, = include a line=20 containing: UNSUB ORACLE-L</FONT> <BR><FONT size=3D2>(or the name of = mailing=20
 |
 |