Re: Oracle Server tuning guide for RAC nodes (2-node and 3-node) with 64-GB and 128GB memory

  • From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • To: Pradeep.Chetal@xxxxxxxxxxxxxx
  • Date: Tue, 4 Aug 2009 19:56:12 -0700

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@xxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: