[HPADM] Summary: Oracle 64 bit Memory Question

From: Latone, Philip (PLatone_at_miracosta.edu)
Date: 08/14/03

  • Next message: Wright, Richard: "[HPADM] [SUMMARY] XP unused disks" 
    Date: Thu, 14 Aug 2003 10:55:02 -0700
To: <hpux-admin@DutchWorks.nl>

      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)
  • Next message: Wright, Richard: "[HPADM] [SUMMARY] XP unused disks"

    Relevant Pages