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