Re: A Book Suggestion for Performance Tuning 10g & 11g
- From: John Hurley <hurleyjohnb@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 28 Jan 2013 17:15:57 -0800 (PST)
Pretty good list for sure.
Personally I would recommend reading Cary Millsaps book several times from
cover
to cover ... then do it again ... and again.
Do that before looking at any of the other books. Period.
You need to have a methodology and a perspective before digging into details.
Your mileage may vary ...
----- Original Message ----
From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Mon, January 28, 2013 8:09:34 PM
Subject: Re: A Book Suggestion for Performance Tuning 10g & 11g
On 28/01/2013 2:01 AM, Sheldon Quinny wrote:
> Hi,
> I am looking for any recommendation or Material for Performance Tuning on
> Database.
My suggestions, and the references I use, in the order of importance:
1) Performance Tuning Guide found at
http://www.oracle.com/pls/db112/homepage
- this goes through it all, at a reasonable price. Most people
[foolishly] ignore it.
2) Expert Oracle Database Architecture: Oracle Database 9i, 10g, and
11g Programming Techniques and Solutions
by Thomas Kyte
(http://www.amazon.com/Expert-Oracle-Database-Architecture-Programming/dp/1430229462)
- this reviews the aspects of the app that should have been addressed
before attempting to tune the DB. This is a step most people [foolishly]
ignore.
3) Oracle Core: Essential Internals for DBAs and Developers by Jonathan
Lewis
(http://www.amazon.com/Oracle-Core-Essential-Internals-Developers/dp/1430239549)
- this explains how it actually works, so you can think your way through
the operational paths. Most people [foolishly] ignore this as 'theory -
bah'.
4) Optimizing Oracle Performance by Cary Milsap
(http://www.amazon.com/Optimizing-Oracle-Performance-Cary-Millsap/dp/059600527X)
- goes through general approach in approaching performance, including
how to get at the information through Trace files. Somewhat advanced, it
discusses what you need to understand BEFORE starting performance
troubleshooting. Most people [foolishly] skip this step and think they
can dive right into the depths. Then they wonder why the changes they
implement make performance worse.
5) Troubleshooting Oracle Performance by Christian Antognini
(http://www.amazon.com/Troubleshooting-Oracle-Performance-Christian-Antognini/dp/1430242965)
- walks through the techniques for tuning, quite well. And is brilliant
if you have slogged through, and have an inkling about, the above.
6) Oracle Wait Interface: A Practical Guide to Performance Diagnostics &
Tuning by Richmond Shee (Author), Kirtikumar Deshpande (Author), K.
Gopalakrishnan
(http://www.amazon.com/Oracle-Wait-Interface-Performance-Diagnostics/dp/007222729X)
- gives some practical information on how to resolve certain waits,
assuming you have identified them correctly by using the techniques
found in 1-5 above.
- Know your application
- Know your data
- Know Oracle internals
- Know your application (better)
- Know how to get relevant information
and finally,
- Know how to tune
HTH
/Hans
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
