FreeLists / oracle-l / How much memory(RAM) required for OS running Oracle

["Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>]

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

 

Environment: Oracle 10.2.0.3 on RHAT4

 

Thanks

--Harvinder