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" <Rich.Jesse_at_qtiworld.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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_at_qtiworld.com QTI -- Sussex, WI USA
>
> > -----Original Message-----
> > From: Kimberly.smith_at_gmd.fujitsu.com
> > [mailto:Kimberly.smith_at_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_at_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_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).
> >
> > --
> > Author:
> > INET: Kimberly.smith_at_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_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).
> >
>
>
>-----------------------------------------------------------------------
>
>This message has been scanned for viruses with Trend Micro's Interscan
>VirusWall.
>--
>Author: Jesse, Rich
> INET: Rich.Jesse_at_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_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).