I'm looking for a good web source for learning about tuning Oracle SQL
statements.
Any suggestions?
Thanks

On Wed, 25 Jun 2003 19:27:21 -0400, "Petee" <dkj> wrote:

You can take a look at the online Oracle manual. there you will find
all the information that you will ever need.

http://otn.oracle.com

Thanks

Peter wrote:

[Come on Peter - he's so new, the least you can do is tell him where to
look on OTN and which books/manuals will be useful.]

Petee - Go to OTN, click on Documentation (this is pretty well the same as
going to http://tahiti.oracle.com or http://docs.oracle.com), select
Database, then select the database version you want. List all the books &
you will find the Concepts manual - which is a prerequisite to
understanding all the rest - as well as the Performane Tuning Guide and
Reference and a number of Programmer's Guides (which have language related
performance tips.)

For specific tuning issues, go to http://asktom.oracle.com and search by
keyword.

Cheers,
Dave



Petee wrote:

I know you asked for a web resource but Oracle Tuning 101 is an excellent
book source. You could always read the tuning guide from the docs as well.
"Petee" <dkj> wrote

There are several good books on SQL tuning by Oracle Press and
O'Reilly, as I recall.

Just go to Amazon and search for "oracle sql tuning".

"Niall Litchfield" <n-litchfield (AT) audit-commission (DOT) gov.uk> wrote

tuning 101 is a great book but it doesnt focus on sql.

Guy harrisons Sql Tuning book is all sql. However, he states that in
some cases using a cursor and then updating off the cursor can be
faster than doing an update with exists...

dont know if that is correct. I ran that every which way and how with
all types of table combinations and size, etc...

it was ALWAYS slower. and alot slower. Everything else seems accurate
as far as I can tell, but Im not a tuning expert.

"Niall Litchfield" <n-litchfield (AT) audit-commission (DOT) gov.uk> wrote

May I second on Oracle Performance Tuning 101 as a good reference.
If you search this discussion Group you may be able to
find a set of useful sites put out in response to a question
in these lines asked sometimes earlier.

Michael Tubuo Ngong

"Petee" <dkj> wrote


Web source? I'd dig into otn and metalink as primary
sources. And Steve Adams' and Jonathan's sites for the
bits not covered anywhere else.

But there is nothing better than a book. For SQL tuning
exclusively, still have to find anything more concise or
helpful than Guy Harrison's SQL Tuning. 2nd edition.

Cheers
Nuno Souto
wizofoz2k (AT) yahoo (DOT) com.au.nospam

"koert54" <nospam (AT) nospam (DOT) com> wrote

More opinions/reviews about "Art and Science of Oracle performance
Performance tuning " will be greatly appreciated.
TIA
Michael Tubuo Ngong