But I need that 1tb of buffer cache, otherwise my hit ratio is only 99.9995% and my users are complaining about slow performance :( Niall Litchfield Oracle DBA Audit Commission +44 117 975 7805 > -----Original Message----- > From: JBECKSTROM@xxxxxxxxx > Sent: 25 February 2004 13:58 > To: JBECKSTROM@xxxxxxxxx; mark@xxxxxxxxxxxxxxxx; > oracle-l@xxxxxxxxxxxxx > Subject: RE: 64-bit windows > > > True, but you can only move the db_block_buffers above 3g and > not the whole > SGA. > > >>> mark@xxxxxxxxxxxxxxxx 2/25/04 8:49:25 AM >>> > Actually, this is wrong (wow I never thought I would say that > to one of > Mladen's posts - but hey.. ;) ). > > Even on 32bit Windows you can set a /3GB switch in your boot.ini file, > that will enable processes to go up to 3Gb in size. > > With the /PAE boot.ini switch you can address up to 64Gb of > RAM (though > I'm not sure on the limitations of process sizes with this). > > More info here: > > http://www.microsoft.com/whdc/hwdev/platform/server/pae/PAEmem.mspx > > So Jeffrey - if you've hit your 2Gb "limit" on Windows - you > may want to > look at setting this before upgrading. > > Regards > > Mark > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen Gogala > Sent: 25 February 2004 12:41 > To: oracle-l@xxxxxxxxxxxxx > Subject: Re: 64-bit windows > > > With Windows? Yes. Theoretically you're not, but then you > have a 64-bit version of BSOD which kicks in after 2GB. > > On 02/25/2004 07:36:55 AM, Jeffrey Beckstrom wrote: > > Currently running 32-bit windows, if we move to 64-bit > windows are we > > still limited to the 2 G process size? > > > > > > > > Jeffrey Beckstrom > > Database Administrator > > Greater Cleveland Regional Transit Authority > > 1240 W. 6th Street > > Cleveland, Ohio 44113 > > > > > > -- > Mladen Gogala > Oracle DBA > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put > 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.594 / Virus Database: 377 - Release Date: 24/02/2004 > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.594 / Virus Database: 377 - Release Date: 24/02/2004 > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > > ********************************************************************** This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or professional privilege. Any dissemination, distribution, copyright or use of this communication without prior permission of the sender is strictly prohibited. ********************************************************************** ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------