RE: HP-UX 11.0 64-bit?

        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).
>