Re: Deadly sins againts database performance/scalability

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