On Jul 5, 9:42 am, harvinde..._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
>
> Environment: Oracle 10.2.0.3 on RHAT4
>
> Thanks
> --Harvinder
most of your questions are answered in the appropriate installation
manual, which can be found at tahiti.oracle.com.
Received on Thu Jul 05 2007 - 11:06:54 CDT
