Re: Oracle Server tuning guide for RAC nodes (2-node and 3-node) with 64-GB and 128GB memory
From: Greg Rahn <greg_at_structureddata.org>
Date: Tue, 4 Aug 2009 19:56:12 -0700
Message-ID: <a9c093440908041956q5783fc0dra6ac347b4f2cf4b3_at_mail.gmail.com>
This seems to be a common problem amongst DBAs : looking for paramters to "tune". Just set the memory settings at a reasonable size, run your workload and analyze the SGA Target advice from AWR/ADDM. No need to make a fairly simple task difficult. Then you can spend your time tuning SQL and application design which is where the real bang for the buck is.
Date: Tue, 4 Aug 2009 19:56:12 -0700
Message-ID: <a9c093440908041956q5783fc0dra6ac347b4f2cf4b3_at_mail.gmail.com>
This seems to be a common problem amongst DBAs : looking for paramters to "tune". Just set the memory settings at a reasonable size, run your workload and analyze the SGA Target advice from AWR/ADDM. No need to make a fairly simple task difficult. Then you can spend your time tuning SQL and application design which is where the real bang for the buck is.
On Tue, Aug 4, 2009 at 7:31 PM, Pradeep
Chetal<Pradeep.Chetal_at_mformation.com> wrote:
>
> Tim,
>
> Thanks. However, I wanted to see if folks on this list have some tunable
> parameters for memory of that size, and then we can start from there
> with the work loads.
>
> -- Pradeep
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 04 2009 - 21:56:12 CDT