Re: Deadly sins againts database performance/scalability

On Fri, 05 Dec 2003, damorgan_at_x.washington.edu wrote:

> So somehow the DBA team expects the developers to develop a
> good application without access to DBMS_PROFILER, without
> access to v$ magic views, and without access to other tables
> and views critical to understanding what is happening and
> optimizing performance and scalability. Good one.
>
> Then I imagine they sit around drinking coffee and whining
> about the poor quality of apps developed by your team.

Actually, that is about it. After many battles and executives learning how much my team was hampered in trying to get our app tested on our different deployment environments, I now have full control of now only the development instances, but also complete access to the production instances. (I still relegate the production DBA responsibilities to the DBA team)

The business folks paying the checks weren't happy to learn that bureucracy was in the way of progress. They told the dba team to just open up the doors, completely.

> Once again the issue goes straight to management
> incompetence. The managers in charge of these teams are the
> root source of the problem. They are doing nothing to foster
> cooperation.

Its really that my parent company has never had a group willing to fight for what was needed. Everybody was always located on sight in the motherland headquarters downtown New York. The subsidiary I work for is located in Boston. The people making these ridiculous decrees had to answer to a group of developers and architects that they didn't manage. When the questions started coming out and climbing up the email escalation threads, the business folks started waking up to the power that the internal IT group held, and they didn't like it, one bit.

-- 
Galen Boyer