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 <[EMAIL PROTECTED]> > Date: 2003/10/29 Wed PM 12:59:34 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 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. > [EMAIL PROTECTED] > > -----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 <[EMAIL PROTECTED]> > > Date: 2003/10/29 Wed AM 10:49:25 EST > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > 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. > > [EMAIL PROTECTED] > > > > -----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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).