Re: Non-performant queries

> My question is, does anyone have any white papers or documents on a
> beginners guide to solving problematic SQL. SQL Trace, tkprof, explain
plans
> etc. I have attempted to look at this sort of thing from text books etc
but
> either I am missing something or are just a bit simple but I just don't
get
> it.

Part VI - "Optimization of SQL Statements" from the "Oracle Concepts" manual

"Piranhas in the Pool : SQL Performance Killers" http://harbinger.sirma.bg/Oracle/N134_sql_pool.pdf

"Oracle Performance and Tuning: Overview" http://harbinger.sirma.bg/Oracle/N014_p&t_overview.pdf

"Performance Tuning - Now You are the V8 Expert" http://harbinger.sirma.bg/Oracle/N023_tun_all.doc

"SQL Tuning for the Oracle DBA"
http://harbinger.sirma.bg/Oracle/N050_tuning.pdf

"Seven Deadly SQL Traps and How to Avoid Them" http://harbinger.sirma.bg/Oracle/N082_tuning.doc

"Secrets of SQL and Application Tuning"
http://harbinger.sirma.bg/Oracle/N108_tuning.doc

hth,

    Marin

"The important thing for all of us is never look *at* the bars, look *through* them. Because if you keep looking *at* bars, you'll never get anything done, and you'll never have fun in life, any joy."

                                                  William Wharton, "Pride"