interesting and valid points, but i'm not sure how they relate to my post...
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1069450115.433539_at_yasure...
| mcstock wrote:
|
| > most of the nasty performance problems i've seen have to do with not how
| > efficiently the work is being done (i.e., good hit-ratio) but with how
much
| > unnecessary work is being done
| >
| <snipped>
| >
|
| In my experience most tuning problems have nothing to do with the
| SGA or hit ratios or anything requiring senior level skillls. Most
| tuning problems come down to lazyiness and ignoring basic skills.
|
| How many people are really running Explain Plan or autotrace?
| How many people are really running DBMS_PROFILER?
| How many people build indexes and never check to see if they are used?
| How many people just assume EXISTS is faster than IN and never verify?
| And as Tom Kyte would likely say ... how many people are really using
| bind variables?
|
| And I'll bet the answer to all of the above questions is not more than
| 5% of all developers and DBAs.
| --
| Daniel Morgan
| http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
| http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
| damorgan_at_x.washington.edu
| (replace 'x' with a 'u' to reply)
|
Received on Fri Nov 21 2003 - 15:43:20 CST
