Setting oracle SGA and other params for large memory boxes

From: "Pradeep Chetal" <Pradeep.Chetal@xxxxxxxxxxxxxx>
To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 10 Nov 2009 15:02:49 -0500


Hi,



We have some new DB systems with larger memory - around 64 GB. We used
to have settings for 32 GB boxes before but the new ones have larger
memory. Since these are dedicated DB Servers, what is the best place to
use the additional memory? Increase sga_maz_size, java_pool,_size,
shared_pool_size,  db-cache_size, ?/



Are there are guidelines for these from Oracle? This is 10gr2 with RAC.



Thanks



-- Pradeep







Pradeep Chetal
Sr. Director - Infrastructure Architecture



Mformation Technologies Inc.
Switchboard: +1 732 692 6200



Visit WWW.MFORMATION.COM and see how the MFORMATION SERVICE MANAGER can help 
you to transform your business


Please consider the environment before printing

This message and the information contained herein is proprietary and 
confidential and subject to the Mformation Confidentiality  policy statement,
you may request a copy by emailing info@xxxxxxxxxxxxxx

Follow-Ups:
- RE: Setting oracle SGA and other params for large memory boxes
  - From: Allen, Brandon

References:
- Negative ramifications of setting CPU_COUNT lower?
  - From: Charles Schultz
- RE: Negative ramifications of setting CPU_COUNT lower?
  - From: Mark W. Farnham

Setting oracle SGA and other params for large memory boxes

Other related posts: