Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How much memory(RAM) required for OS running Oracle
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
Received on Thu Jul 05 2007 - 09:42:40 CDT
![]() |
![]() |