Re: Query tuning exercise: what to look for in a 10053 trace

Bernard,

Over the years I've come to appreciate someone who can summarize a complex
topic in a few succinct statements. Just to clarify for the rest of us,
please confirm that you are referring to:

 -  Oracle Wait Interface: A practical Guide to Performance Diagnostics and
Tuning (Osborne Oracle Press Series) by Richmond Shee, Kirtikumar Deshpande,
and K. Gopalakrishnan
 -  Cost-Based Oracle Fundamentals by Jonathan Lewis (I didn't know this
was out).
 -  SQL Tuning by Dan Tow

My only quibble is that there needs to be a place in your pantheon for
 -  Optimizing Oracle Performance by Cary Millsap and Jeff Holt.
I'm not sure what that does for your letter arrangement. Of course, since
the topic is SQL statement tuning, you could argue that Cary looks more
broadly to the application performance, rather than focusing on a specific
SQL statement.

Dennis Williams


On 7/26/06, Bernard Polarski <bpolarsk@xxxxxxxxx> wrote: 

  Here we find again the holy trinity : DUC

   Diagnose-Understand-Cure

D : Why is my DB so slow --> Oracle wait interface (Oracle press)
U : Why the CBO is doing that --> Cost based optimisation (JL)
C : What should I do now --> Dan Tow, SQL tuning (Oreilly)


Other related posts: