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: RE: SQL and PL/SQL tuning template document required urgently

Re: RE: SQL and PL/SQL tuning template document required urgently

From: <ryan_oracle_at_cox.net>
Date: Wed, 29 Oct 2003 09:24:25 -0800
Message-ID: <F001.005D4F37.20031029092425@fatcity.com>


the original poster sent me an email stating that he doesnt want a book or documentation, he just wants some sort of short cut template. i replied that if one exists its garbage. He didnt respond.

A side note, it seems to be in vogue to recommend advanced books like carrie millsap's and tom kytes to beginners. This isnt appropriate. Beginners should start with beginning material and work their way up. Starting with advanced material will just confuse them.

>
> From: DENNIS WILLIAMS <DWILLIAMS_at_lifetouch.com>
> Date: 2003/10/29 Wed AM 10:49:25 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: SQL and PL/SQL tuning template document required urgently
>
> Ranganath
> Since you mentioned proactive and reactive query tuning, I think the
> philosophy with which one approaches the tuning exercise means everything.
> Wrong philosophy and you spend your time spinning your wheels. All of us
> have only a limited amount of time to devote, so the best approach will make
> the best use of that time.
> Get "Optimizing Oracle Performance" by Cary Millsap. It doesn't take long
> to read the important parts. Implement Cary's approach to locate the queries
> where you will get the most bang for the buck. Then use books like Guy
> Harrison's (Ryan's suggestion) for pointers on making those queries perform
> better.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Wednesday, October 29, 2003 8:24 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi there,
>
> Does any body have a template for proactive and reactive query
> tuning which can be used as a guideline/report while tuning simple, medium
> complex and complex SQL queries and PL/SQL stored procedures? If so, can
> you please forward the same to me please? If not, can anybody suggest as to
> how to go about doing one? Any help in this regard is very much
> appreciated.
>
> Thanks and Regards,
>
> Ranganath
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ranganath K
> INET: Ranganath_K01_at_infosys.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <ryan_oracle_at_cox.net
  INET: ryan_oracle_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Wed Oct 29 2003 - 11:24:25 CST

Original text of this message

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