Re: Deadly sins againts database performance/scalability

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 08 Dec 2003 09:24:45 -0800
Message-ID: <1070904318.1969@yasure>

Billy Verreynne wrote:

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

>>And not once has anyone addressed my statements about granting access to 
>>developers to the v$ magic views and many of the DBMS and UTL packages 
>>and I would bet a Latte' at Starbucks you don't give your developers 
>>access to them either.

>
>
> Well, on our DEV platform I have given the developer accounts select
> access to the v$ magic views in a vain hope that with a little bit of
> self empowerment, they will get to know Oracle better and even use it
> better.
>
> But then I still get stuff like this in production:
> begin
> insert statement (trigger updates the seq)
>
> select max(seq) into :s from table;
>
> return( :s )
> end;
>
>
> Code review? Not here. Every developer writes perfect code. Why the
> hell get the DBA involved at all (except when you want to use him as a
> friggen reference manual when too lazy to look up the syntax for an
> Oracle function or SQL statement).
>
> --
> Billy

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

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

-- 
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 Mon Dec 08 2003 - 11:24:45 CST