Re: Deadly sins againts database performance/scalability

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 08 Dec 2003 23:09:59 -0800
Message-ID: <1070953831.702280@yasure>

Billy Verreynne wrote:

> Daniel Morgan <damorgan_at_x.washington.edu> wrote
>
>

>>That's half a latte'. How about DBMS_PROFILER and other built-in packages?

>
>
> They don't know how to use expain plan.

Shame shame shame!

Better than what I'm really thinking.

  I have tried numerous times to
> get them to use TKPROF. Access to DBMS_PROFILER? They won't know what
> to do with it.

I have a rule ... no code goes into production without accompanying explain plans and DBMS_PROFILER runs. It is part of the rules of engagement and should be mandatory everywhere.

Any developer can learn Explain Plan in five minutes: DBMS_PROFILER in thirty or less.

>>If you get it right send me your postal address off-line and the latte' 
>>is yours.

>
>
> Does it come with several cases of beer? ;-)
>
> --
> Billy

I keep Chimay in the frige but it doesn't ship well.

-- 
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 Tue Dec 09 2003 - 01:09:59 CST