| 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_01C04B4C.58AB5016
Content-Type: text/plain;
charset="iso-8859-1"
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]
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.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_01C04B4C.58AB5016 Content-Type: text/html; charset="iso-8859-1" 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=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: init.ora PROCESS parameter</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Hi Larry, </FONT> </P> <P><FONT SIZE=3D2>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.</FONT></P> <P><FONT SIZE=3D2>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.</FONT></P> <P><FONT SIZE=3D2>HTH...</FONT> </P> <P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator</FONT> <BR><FONT SIZE=3D2>Qode.com</FONT> <BR><FONT SIZE=3D2>4850 North State Road 7</FONT> <BR><FONT SIZE=3D2>Suite G104</FONT> <BR><FONT 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 </FONT> <BR><FONT SIZE=3D2>C: 954.658.5849</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A></FONT> </P> <P><FONT SIZE=3D2>"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."</FONT></P> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Larry Taylor [<A = HREF=3D"mailto:ltaylor_at_iq.com">mailto:ltaylor_at_iq.com</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Friday, November 10, 2000 2:11 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT 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 init.ora file</FONT> <BR><FONT SIZE=3D2>affect the performance of the database. I can't seem = to find any good</FONT> <BR><FONT SIZE=3D2>information</FONT> <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> </P> <P><FONT SIZE=3D2>#processes =3D = 50 &nbs= p; &nbs= p; &nbs= p; &nbs= p; #</FONT> <BR><FONT SIZE=3D2>SMALL</FONT> <BR><FONT SIZE=3D2># processes =3D = 100 &nb= sp; &nb= sp; &nb= sp; &nb= sp; #</FONT> <BR><FONT SIZE=3D2>MEDIUM</FONT> <BR><FONT SIZE=3D2>#processes =3D = 200 &nb= sp; &nb= sp; &nb= sp; &nb= sp; # 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 the process</FONT> <BR><FONT SIZE=3D2>value is greater</FONT> <BR><FONT SIZE=3D2>than 800.</FONT> </P> <P><FONT SIZE=3D2>Thanks for any help you can provide.</FONT> <BR><FONT SIZE=3D2>larry</FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Larry Taylor</FONT> <BR><FONT SIZE=3D2> INET: ltaylor_at_iq.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Fri Nov 10 2000 - 13:28:03 CST
 |
 |