| 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: Limits
Flávio - Well, Oracle warns you not to mess with the cpu_count parameter.
Also it seems to be very O.S. specific. My guess is that it is more of a
reference in case your program needs to know the number of CPUs.
Another issue is whether the O.S. would honor this setting. You haven't mentioned your O.S., so I'll use Unix as an example. Oracle spawns processes. The O.S. schedules them to CPUs. That is an O.S. task, not an Oracle responsibility. Again, at the O.S. level, there is probably a way to limit Oracle to a single CPU. By the way, some vendors are offering systems that allow dynamic configuration of CPUs, when you need more, call them and their support people will switch more CPUs on.
Now, let's assume you achieved success at a technical level. You have technically limited the CPUs to something less than what is physically installed. Can you convince Oracle to go for it. Well, if you read the other note posted on this list, Oracle even wants you to pay for standby, failover, disaster recovery databases. All I can say is if you convince your Oracle salesperson, let us know.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Thursday, January 16, 2003 5:39 AM
To: Multiple recipients of list ORACLE-L
Ron and Denis,
I discovered a parameter to do it, called cpu_count that I can limit the number of processors used for Oracle. Now, my new question is: if I have a server with 2 processors but i'm using only one for Oracle (with this parameter), do I have to buy 1 or 2 processors license?
The size of SGA is really the total (I say really the total) RAM used for Oracle?
Thanks
Flávio
-----Mensagem original-----
De: Ron Rogers [mailto:RROGERS_at_galottery.org]
Enviada em: quarta-feira, 15 de janeiro de 2003 17:45
Para: Multiple recipients of list ORACLE-L
Assunto: RE: Limits
Flavio,
I agree with what Dennis said about the limiting of ram usage by
Oracle but,
The init.ora setting will establish what you would like to use for the
oracle settings and it is best if it is contigious memory also. On the
OS OpenVMS there is a OS setting that will reserve memory in a
contigious area for the Oracle ram needs. This setting can be larger
that the actual needs and cause ram to be wasted because it is reserved
for oracle. Check with your sys admin to see if there are any limiting
settings for the oracle instance and adjust accordingly.
Ron
>>> DWILLIAMS_at_LIFETOUCH.COM 01/15/03 03:14PM >>> Flavio - You control the amount of RAM by your init.ora settings.
Limiting processor usage is probably up to your O.S., and you didn't
mention
which O.S. you are on. This is probably not a good idea. Modern
operating
systems do a pretty good job of prioritizing the work, and limiting by
CPU
is a rather crude method.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, January 15, 2003 1:10 PM
To: Multiple recipients of list ORACLE-L
Hi all!
I need to know if is possible to limit Oracle to use only one
processor, in
a machine that has 2 processors?!
And if is possible to limit RAM too? Can I limit Oracle usage of RAM memory?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?iso-8859-1?Q?Fl=E1vio_Reis?=
INET: freis_at_metrored.com.br
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Rogers
INET: RROGERS_at_galottery.org
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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). Received on Thu Jan 16 2003 - 07:28:54 CST
 |
 |