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 -- http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- 10g RAC and db_multi_block_read_count
- From: Crisler, Jon
- 10g RAC and db_multi_block_read_count
- References:
- Re: expdp and ORA-01555
- From: Rich
- RHEL5/10.2.0.4.0
- From: Maureen English
- Oracle Server tuning guide for RAC nodes (2-node and 3-node) with 64-GB and 128GB memory
- From: Pradeep Chetal
- RE: Oracle Server tuning guide for RAC nodes (2-node and 3-node) with 64-GB and 128GB memory
- From: Pradeep Chetal
- Re: expdp and ORA-01555
Other related posts:
- » Oracle Server tuning guide for RAC nodes (2-node and 3-node) with 64-GB and 128GB memory - Pradeep Chetal
- » RE: Oracle Server tuning guide for RAC nodes (2-node and 3-node) with 64-GB and 128GB memory - Bobak, Mark
- » RE: Oracle Server tuning guide for RAC nodes (2-node and 3-node) with 64-GB and 128GB memory - Pradeep Chetal
- » Re: Oracle Server tuning guide for RAC nodes (2-node and 3-node) with 64-GB and 128GB memory - Greg Rahn
- » RE: Oracle Server tuning guide for RAC nodes (2-node and 3-node) with 64-GB and 128GB memory - Crisler, Jon
- » RE: Oracle Server tuning guide for RAC nodes (2-node and 3-node) with 64-GB and 128GB memory - Mark W. Farnham
- » RE: Oracle Server tuning guide for RAC nodes (2-node and 3-node) with 64-GB and 128GB memory - Pradeep Chetal