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:[EMAIL PROTECTED]] 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 >>> [EMAIL PROTECTED] 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. [EMAIL PROTECTED] -----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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: =?iso-8859-1?Q?Fl=E1vio_Reis?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
