Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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). Received on Wed Jan 15 2003 - 14:44:51 CST
![]() |
![]() |