Kimberly,
Yes, the 32-bit version of Oracle usually caps the size of the
SGA between 1.3 - 1.6 Gb depending on platform. The norm seems
to be more like 1.4/1.5 Gb. So anything larger than that
requires the 64-bit option. This is even after the base address
for the SGA is relocated.
Best Regards,
Gaja.
- Kimberly.smith_at_GMD.FUJITSU.COM wrote:
> 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).
Gaja Krishna Vaidyanatha
Director, I-O Management Products
Quest Software Inc.
(972)-304-1170
gajav_at_yahoo.com
"Opinions and views expressed are my own and not of Quest"
Received on Tue Jul 18 2000 - 18:03:15 CDT
