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

Neither Tom Kyte's nor Cary Millsap's books are too advanced for beginners.

In the case of Tom's book, they may have to ponder things a bit, and actually try
the code for themselves to get a good understanding. So what? That's how you learn.

Regarding Cary's book, what's so hard about it? Beginner's could do much worse by reading some of the claptrap pablum that is available, but that will
just make it harder for them to understand the good stuff when they see it.

Also, re the comments about the math in Cary's book: What's the big deal? So what if you don't understand the math? There isn't really that much of it,
and you can undestand the material even if you can't follow the proof.

Jared

Oracle - steroids for your brain.

<ryan_oracle_at_cox.net>
Sent by: ml-errors_at_fatcity.com
 10/29/2003 09:24 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re: RE: SQL and PL/SQL tuning template document required 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: 
  INET: Jared.Still_at_radisys.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).