Message-Id: <10562.112350@fatcity.com> From: "Madhavan Amruthur" Date: Tue, 18 Jul 2000 16:12:32 PDT Subject: RE: HP-UX 11.0 64-bit? Hi, You can have big SGA's on a 32 bit system also. On a Sequent (now IBM) NUMA the init.ora parameter use_indirect_data_buffers can be used and the SGA can be upto the physical memory. The size of one SHM segment is a max of 4G though. The use_indirect_data_buffers uses the virtwin calls that enables SGA definitions of > the 2.5 GB limit. We defined an SGA of 9GB for a benchmarking effort on a NUMA with 16GB memory. Hope this helps. Regards, Madhavan IBM Corporation >From: "Jesse, Rich" >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >Subject: RE: HP-UX 11.0 64-bit? >Date: Tue, 18 Jul 2000 15:36:12 -0800 > >From Metalink Forum (dated 10/1999): > > SGA Maximums > > Oracle7 (32bit) 2.25GB > Oracle8 (32bit) 2.5GB > Oracle8 (64bit) Upper limit greater than possible physical memory > >So, yes, you would need the 64bit version for very large SGAs. I'm not >sure >how they got those numbers, though, as 2^32 is 4GB or for a signed integer, >2^31, would be 2GB. > >My guess is that the 64bit version would support SGA sizes of a little over >9 Exabytes >(9EB or 2^63 or 9*10^18). Imagine the memory check on boot for that box! >;) > >Rich Jesse System/Database Administrator >Rich.Jesse@qtiworld.com QTI -- Sussex, WI USA > > > -----Original Message----- > > From: Kimberly.smith@gmd.fujitsu.com > > [mailto:Kimberly.smith@gmd.fujitsu.com] > > Sent: Tuesday, July 18, 2000 17:54 > > To: Multiple recipients of list ORACLE-L > > Subject: RE: HP-UX 11.0 64-bit? > > > > > > Do you actually need to use 64-bit Oracle to get a SGA that big? > > I know that you can put more memory in a 64-bit HP install which > > is why we went that way but I did not know there was a restriction > > on how much Oracle could use, regardless of the bit. > > > > -----Original Message----- > > Conron > > Sent: Tuesday, July 18, 2000 3:01 PM > > To: Multiple recipients of list ORACLE-L > > > > > > On Tue, 18 Jul 2000, you wrote: > > > Are their any particular reasons why you would want to go > > to 64 bit??? > > > Is your application 64 bit ??? > > > What does your aplication vendors say???? > > > > For us it's increased SGA. We're running the same version of > > Oracle and HP-UX as you, but are heading to 64-bit 8.1.6 (64-bit > > 8.0.5 has a nasty partitioned-table bug, causing > > end-of-communication-channel errors). We can then bump the SGA > > from it's current size of ~1.2 GB to about 8 GB (the box has 12 > > GB ram, and Oracle is the sole purpose of the box. Why not use > > as much as possible :) > > > > As a bonus we'll get some of the nifty features of 8.1.6 > > > > Cheers, > > GC > > -- > > I love the way Microsoft follows standards. In much the > > same manner that fish follow migrating caribou. > > -- > > Author: Gregory Conron > > INET: gconron@hfx.andara.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@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). > > > > -- > > Author: > > INET: Kimberly.smith@gmd.fujitsu.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@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). > > > > >----------------------------------------------------------------------- > >This message has been scanned for viruses with Trend Micro's Interscan >VirusWall. >-- >Author: Jesse, Rich > INET: Rich.Jesse@qtiworld.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@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). ________________________________________________________________________