Re: O 8.0.5 SGA size HPUX 11

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 23 Jun 2001 15:10:59 +0100
Message-ID: <993305288.4155.0.nnrp-13.9e984b29@news.demon.co.uk>

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.

>

Received on Sat Jun 23 2001 - 09:10:59 CDT