Re: RE: Useful Oracle books

From: <Jared.Still_at_radisys.com>
Date: Thu, 27 May 2004 11:36:21 -0700
Message-ID: <OFD311CAA6.CA66F615-ON88256EA1.00660728-88256EA1.00663456@radisys.com>

> 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).
Perhaps an example would help. I don't have the book handy to check, but there are cases where updating inside is cursor is very fast.

Ever used "where current of"?

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

"Cary" is of the male gender. Maybe that will help.

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

OK? You either didn't read it, or didn't learn anything from it.

Jared

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:33:34 CDT