Re: A Book Suggestion for Performance Tuning 10g & 11g

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Mon, 28 Jan 2013 18:08:31 -0700
Message-ID: <5107210F.5050702_at_gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 29 2013 - 02:08:31 CET

Original text of this message