Re: How much memory(RAM) required for OS running Oracle

On Thu, 05 Jul 2007 07:42:40 -0700, harvinder76_at_gmail.com wrote:

>Hi,
>
>We are setting up couple of boxes on Linux with different hardware
>specs and trying to prepare a document that can be used as general
>guidelines for future installations.
>In SQL Server installations, for system with <16GB we allocate 1GB for
>OS and rest of memory for Database and for system with >16GB we
>allocate 2GB for OS and rest of memory for database.
>So we are wondering how much memory is required by OS(Linux) for
>Oracle installation and allocate remaining memory for Database (SGA +
>PGA etc).
>Also By default Oracle recommends 40% of RAM for SGA but that may be
>good for small system but may not be applicable for large system. It
>is also true that we can't have a generic set
>of recommendations since it also depends upon the application and
>other factors etc but still it will be good to have some starting
>point (not 40%) so that DBA can configure the system and then modify
>the settings as required. It may be possible that such type of
>document already exists and it will be great if can point me to
>location or send me your feedback about what can SGA+PGA are set for
>particular RAM on machine, so document will look like:
>
>RAM (GB) DB_CACHE_SIZE
>SHARED_POOL_SIZE PGA_AGGREGATE_TARGET
>LARGE_POOL_AREA JAVA_POOL_SIZE etc
>
>2
>4
>8
>12
>16
>32
>64
>

PGA is dependant on # of connections
SGA on the type of your application, and how well it's tuned. Usually 1-2G should be more than enough

.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Thu Jul 05 2007 - 15:39:53 CDT