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

Ryan - Thanks for updating us on the status with the user.

As to what we recommend to novice users, as a practical matter, unless the poster makes their experience or lack thereof clear, I just have to make an assumption. In this case, since the poster was talking about guidelines and templates, my assumption was that the poster was setting policy for his/her site, but I perhaps I made a different assumption based on few facts than you made.

   As to Cary's book being too advanced for beginners, here is my opinion: First, Cary has made great efforts to ensure the bulk of his book is very clear for even managers. And he makes it clear you don't need to understand Part 2 in order to benefit. Second, if anyone, especially a beginner, takes the wrong approach to tuning, they can waste many months of effort with few results (beyond imagined progress). I feel Cary's book offers the best approach to tuning available today. But an alternative I could suggest is Christopher Lawson's Oracle Performance Tuning. He offers a nice balance between the philosophy of tuning as well as practical tips for tuning specific queries.

   Sams Publishing puts a "User Level" rating on their books. Maybe we should ask O'Reilly to do the same. How about that Jonathan?

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, October 29, 2003 11:24 AM To: Multiple recipients of list ORACLE-L urgently

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