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

From: Chris Dunscombe <cdunscombe_at_yahoo.com>
Date: Wed, 30 Jan 2013 09:18:21 +0000 (GMT)
Message-ID: <1359537501.50117.YahooMailNeo_at_web171404.mail.ir2.yahoo.com>

Hi,
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.

Cheers,

Chris

---

 From: Sheldon Quinny <sheldonquinny_at_gmail.com> To:
Cc: Oracle-L Freelists <oracle-l_at_freelists.org> 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.
-Sheldon.

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

> This a great list from Hans, that I second that list:
> 1)  Performance Tuning Guide  http://www.oracle.com/pls/db112/homepage
> 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
> http://dboptimizer.com
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

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