Re: Another Oracle "Myth"?

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)