| 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
> 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). -- 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).Received on Wed Oct 29 2003 - 13:54:25 CST
 |
 |