Re: How big SGA for 32GB RAM

From: "David Sharples" <davidsharples@xxxxxxxxx>
To: Harvinder.Singh@xxxxxxxxxxxxx
Date: Thu, 18 Jan 2007 20:44:21 +0000

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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>
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.

Follow-Ups:

Re: How big SGA for 32GB RAM
From: Don Seiler

References:
- How big SGA for 32GB RAM
  - From: Harvinder . Singh

Other related posts:

Browse oracle-l