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

From: Chris Dunscombe <>
Date: Wed, 30 Jan 2013 09:18:21 +0000 (GMT)
Message-ID: <>

If you're looking at SQL tuning then I'd also recommend "Cost Based Oracle Fundamentals" by Jonathan Lewis. This book provides a great insight into how the optimizer works and is very helpful in understanding why the optimizer makes certain choices regarding execution plans.

BTW This isn't a basic book but well worth the effort of reading, and re-reading.



 From: Sheldon Quinny <> To:
Cc: Oracle-L Freelists <> Sent: Tuesday, 29 January 2013, 10:58
Subject: Re: A Book Suggestion for Performance Tuning 10g & 11g  

Thanks to everyone for providing me with suggestion for the books. Very Much Appreciated.

Thank you.

On Tue, Jan 29, 2013 at 7:30 AM, kyle Hailey <> wrote:

> This a great list from Hans, that I second that list:
> 1)  Performance Tuning Guide
> 2)  Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g -
> Kyte
> 3)  Oracle Core: Essential Internals for DBAs and Developers by J Lewis
> 4)  Optimizing Oracle Performance by Cary Milsap
> 5)  Troubleshooting Oracle Performance (TOP) by Christian Antognini
> 6)  Oracle Wait Interface
> I really like TOP.
> Just to add my 2 cents, if you are interested in SQL tuning  I think the
> following two are under-rated
>    - Refactoring SQL by Stephane Faroult
>    - SQL Tuning  by Dan Tow
> Stephane's book is a easy read and should be read by every DBA who has any
> exposure to developers especially java programmers who try and access the
> database.
> Dan's book is a more challenging dry read but it's the only book that lays
> out a straight forward methodology for finding an optimal execution path
> candidate. The method requires work, but the good new is that DB Optimizer
> from Embarcadero does most of the busy work. DISCLAMER: I was the designer
> behind DB Optimizer I'm biased.
> - Kyle Hailey
> --

Received on Wed Jan 30 2013 - 10:18:21 CET

Original text of this message