Re: RE: Useful Oracle books

From: <ryan.gaffuri_at_cox.net>
Date: Thu, 27 May 2004 14:10:56 -0400
Message-Id: <20040527181055.XMQ15361.lakermmtao07.cox.net@smtp.east.cox.net>

Harrison's book is 'ok'. Doesn't teach you how to tune and has a huge and pretty pathetic error in it. It says you can improve performance of some updates by using a cursor and updating inside the cursor. Its actually takes about twice as long or worse. Clearly he never tested that statement. To be fair the 8i version of Fuersteins pl/sql book has the same error(never read the 9i one).

For SQL Tuning the #1 must read is 'SQL Tuning' by Dan Tow. He uses graph theory to show you a process for tuning queries. Nothing else on the market even compares.

For overall tuning the book to get is 'Optimizing Oracle Performance' by Carrie Milsap. I also recommend going to www.hotsos.com and reading his articles.

For general Oracle get Tom Kyte's 'Expert one on One'. His tuning book is 'ok', but the other two I mentioned are better.

I would start with those and read the Oracle documentation. Start with the Concepts doc. Skip the stuff on Java, XML, Web stuff...
>
> From: "Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca>
> Date: 2004/05/27 Thu PM 01:46:23 EDT
> To: "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
> Subject: RE: Useful Oracle books
>
> -Oracle SQL High Performance Tuning - Guy Harrison

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu May 27 2004 - 13:07:54 CDT