Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How big SGA for 32GB RAM

Re: How big SGA for 32GB RAM

From: David Sharples <davidsharples_at_gmail.com>
Date: Thu, 18 Jan 2007 20:44:21 +0000
Message-ID: <be592d550701181244s74c2bfcayc6dbf55ef2989589@mail.gmail.com>


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
Received on Thu Jan 18 2007 - 14:44:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US