Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: O 8.0.5 SGA size HPUX 11

Re: O 8.0.5 SGA size HPUX 11

From: Dave Grantier <dave_at_foobar.com>
Date: Sat, 23 Jun 2001 15:58:53 GMT
Message-ID: <3b34bc66.53257390@news.atl.bellsouth.net>

Jonathan,
Thanks for the response.
That's what I've been hearing from others. Any idea why?
I've heard that it doesn't work that way on Solaris...Do you know if that's true?

cheers

On Sat, 23 Jun 2001 15:10:59 +0100, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

> If you are running 32-bit Oracle on 32-bit HP-UX 11,
> then the sum of all SGAs may not exceed 1.7GB,
> and this is more of a limit from HP-UX than it is
> from Oracle.
>
> If you run 32-bit Oracle on 64-bit HP-UX, I __believe__
> that you can use a 'virtual machine' or 'memory
> window' feature of the O/S to run each copy of
> Oracle in it's own memory space , thus allowing
> each instance to have a 1.7 GB SGA.
>
> If you run 64-bit Oracle on 64-bit HP-UX, then
> I don't think you have any such limitation.
>
>
> --
> Jonathan Lewis
>
> Host to The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
> See http://www.jlcomp.demon.co.uk/book_rev.html
>
> Seminars on getting the best out of Oracle
> See http://www.jlcomp.demon.co.uk/seminar.html
>
>
>
>
>
>
> Dave Grantier wrote in message <3b33efb5.856141_at_news.mindspring.com>...
> >Greetings.
> >I have been receiving some conflicting information and was hoping
> >someone could shed some light on the issue.
> >
> >We have an Oracle 8.0.5 database (32 bit) running on an HPUX 11.0
> >server (10 way CPU, 8 Gig RAM). I have been told that the maximum
> >size for the SGA can be around 1.7 gigs or so, due to the 32 bit
> >architecture of the database.
> >
>
>
>

Dave

+---------------------+---------------+

|nojunkmail_at_nospam.com| bellsouth.net |
|nospam_at_nojunkmail.com| davegrantier@ |
+---------------------+---------------+
Received on Sat Jun 23 2001 - 10:58:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US