Re: How big SGA for 32GB RAM

version of oracle, operating system, 32 or 64 bit

details .....

but how about working out what you need instead of just guessing, a 1Gb shared_pool is large, how much sql do you have?

how much data are you dealing with

On 18/01/07, oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> wrote:
>
>
> Hi,
>
> We were installing oracle on 32GB RAM server and configured the
> Shared_pool to 1GB and PGA to 3GB, so wondering what the maximum numbers
> of memory can be allocated for buffer cache or How much memory OS needs
> since rest can be used by database instance. In SQL Server normally we
> allocate 30GB for database and 2GB for OS.
>

--
http://www.freelists.org/webpage/oracle-l