Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Deadly sins againts database performance/scalability

Re: Deadly sins againts database performance/scalability

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 06 Dec 2003 23:02:59 -0800
Message-ID: <1070780613.968896@yasure>


JEDIDIAH wrote:

> On 2003-12-06, Daniel Morgan <damorgan_at_x.washington.edu> wrote:
>

>>Galen Boyer wrote:
>>
>>
>>>On 5 Dec 2003, drak0nian_at_yahoo.com wrote:

>
> [deletia]
>
>>The sad fact is, and since I don't know you Paul I'm not pointing at you 
>>so don't take this personally, the DBAs that are most paranoid about 
>>giving developers privileges in development environments, are the DBAs 
>>that know the least about development: The ones that can't actually 
>>write and debug PL/SQL.

>
>
> No, it is far more likely that the paranoid DBA has little or no
> respect for the developers. Developer quality varies widely.
> Some can even be entrusted with the DBA role on production systems.
> However, most can't even be trusted to wipe their own noses.
>
> It is safer to be paranoid.
>
> "can't actually write and debug PL/SQL" is a common problem all round.

You've posted, Paul's posted, others have posted.

I have 10+ years working as an Oracle DBA and I am still looking for concrete, real-world, examples of problems caused in production by developers that were allowed to manage their own sandbox.

If there is something here other than paranoia ... name names. What actually happened? And if a properly written and approved design with code reviews would have solved the problem you don't have a point other than a lack of decent procedures.

I await those examples. I suspect many developers watching here are too.

-- 
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 Sun Dec 07 2003 - 01:02:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US