From: Latone, Philip (PLatone@miracosta.edu)
Date: Thu Aug 14 2003 - 13:55:02 EDT
You are limited to 8,000 gigabytes. In other words, no
practical limit.
SHMMAX is NOT limited by the amount of RAM, it is limited
by virtual memory which is a combination of swap space and
RAM. You can assign 4Gb to SGA for five instances of Oracle
and it will work fine, albeit quite slow due to paging.
Bill
--
Best regards,
Bill Hassell
-----Original Message-----
From: Latone, Philip
Sent: Thursday, August 14, 2003 9:08 AM
To: hpux-admin@DutchWorks.nl
Subject: [HPADM] RE: Oracle 64 bit Memory Question
I an running ORACLE 8i/9i 64bit on HPUX 11.11. What is the combined total RAM ORACLE will not go beyond of all the SGA instances? I have set SHMMAX to the maximum allowed on my machine (4gb). The archives mention 32 bit oracle as having a limit but I was wondering about 64 bit. Thanks.
Here is an excerpt from the archives.
If you are
> running 32-bit Oracle, then Oracle will never use any RAM
> beyond the first 3.75 Gb (and unless you use memory
> windows, all Oracle instances will share that same space).
> 32-bit Oracle is very limited as far as RAM usage.
--
---> Please post QUESTIONS and SUMMARIES only!! <---
To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
Name: hpux-admin@dutchworks.nl Owner: owner-hpux-admin@dutchworks.nl
Archives: ftp.dutchworks.nl:/pub/digests/hpux-admin (FTP, browse only)
http://www.dutchworks.nl/htbin/hpsysadmin (Web, browse & search)
--
---> Please post QUESTIONS and SUMMARIES only!! <---
To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
Name: hpux-admin@dutchworks.nl Owner: owner-hpux-admin@dutchworks.nl
Archives: ftp.dutchworks.nl:/pub/digests/hpux-admin (FTP, browse only)
http://www.dutchworks.nl/htbin/hpsysadmin (Web, browse & search)
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 11:02:32 EDT