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_at_yahoo.com> 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)
>
>

--
http://www.freelists.org/webpage/oracle-l