| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE: SQL and PL/SQL tuning template document required urgently
not sure its about sink or swim. I think its more productive for them to start with basic stuff and get grounded in that first. Saves time. Saves frustration and they learn faster.
>
> From: Jared.Still_at_radisys.com
> Date: 2003/10/29 Wed PM 02:54:25 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
>
> > They really dont know anything and it REALLY is that hard for them.
>
> Hence the lies on their resumes. ;)
>
> OK, enought cynicism. For now.
>
> Maybe it is hard. I guess I just don't agree that they shouldn't just
> dive in and sink or swim.
>
> And yes, I've been doing this a while, but there are still things that I
> find difficult. Often this
> is due to poorly written software and/or documentation, usually the
> latter, sometimes the
> former, and on occasion both. In those cases I don't persist unless
> absolutely necessary.
>
> Whether or not to tackle a tough subject head depends on how badly you
> need to, I guess.
>
> eg. I once had OAS 4.0 working on Windows NT.
>
>
> Jared
>
>
>
>
>
>
> <ryan_oracle_at_cox.net>
> Sent by: ml-errors_at_fatcity.com
> 10/29/2003 11:20 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
>
>
> jared you have been doing this for what 10-15 years now? take someone with
> little to know background in this field and little to no technical
> experience.
>
> tom kytes book is rough and dense from their perspective. soemtimes people
> forget how far removed they are from the true beginner. There is a big
> difference between what is easy for you and what is easy for a beginner.
>
> I think that is why alot of senior people get frustrated when training
> newbies. They really dont know anything and it REALLY is that hard for
> them.
>
> >
> > From: Jared.Still_at_radisys.com
> > Date: 2003/10/29 Wed PM 01:14:37 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
> >
> > 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).
> >
> >
> >
> >
>
> 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).
>
>
>
>
>
| <ryan_oracle@cox.net>
Sent by: ml-errors@fatcity.com 10/29/2003 11:20 AM
|
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com> cc: Subject: Re: RE: SQL and PL/SQL tuning template document required urgently |
| <ryan_oracle@cox.net> Sent by: ml-errors@fatcity.com 10/29/2003 09:24 AM | To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com> cc: Subject: Re: RE: SQL and PL/SQL tuning template document required urgently |
-- 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 - 14:44:25 CST
 |
 |