Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Non-performant queries

RE: Non-performant queries

From: Lee Robertson <Lee.Robertson_at_qspgms.com>
Date: Wed, 12 Jul 2000 10:43:13 +0100
Message-Id: <10556.111772@fatcity.com>


Many thanks, I'll get reading

Regards

Lee

> -----Original Message-----
> From: Marin Dimitrov [mailto:marin_at_sirma.bg]
> Sent: 12 July 2000 11:14
> To: Multiple recipients of list ORACLE-L
> Subject: 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"
>
>
> --
> Author: Marin Dimitrov
> INET: marin_at_sirma.bg
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
> ======================================================
> This message has been scanned and checked by MIMESWEEPER.
Received on Wed Jul 12 2000 - 04:43:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US