i guess i jumped to conclusions, but i took it from the level of his questions. 'basic template' = looking for shortcut = what people look for when they are new to something and want to get started quick = not always a bad idea.
>
> From: DENNIS WILLIAMS <DWILLIAMS_at_lifetouch.com>
> Date: 2003/10/29 Wed PM 12:59:34 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: 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).
>
--
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 - 12:29:40 CST
