Re: DBA's that tune duhveloper's SQL

Deborah,

    Most of the places I have worked, one of the tasks of the production dba is to point out bad sql, suggest changes and follow up. It is more of a political than technical issue. The developers don't have to deal with the performance problems, so have little reason to put forth the extra effort to write good code. One of the other issues is that the development database contains data and structures that are not like production. This usually means that something that runs fine in development becomes a resource killer in production.

    Any chance of convincing the Police Service that writing bad code is a chargeable offense?

-- 
Daniel W. Fink
http://www.optimaldba.com

IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
   Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL
   Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals


IT - Database (Do Not Use) wrote:



> We have a consultant doing some work at our site and he claims that in 

> most shops the DBA's have the responsibility of tuning duhvelopers 

> code.  I find that hard to believe.  I was wondering if maybe I am out 

> of touch.....do most of you also tune all your duhvelopers code???  I 

> can see working together with them if there are issue but have the 

> responsibility of tuning all developer code....EGAD when would I have 

> time to be a DBA.  ; )

>

> Deborah Csongradi   OCP

> Senior Database Administrator

> Edmonton Police Service

> Office:             (780) 421-3567

> Fax:                 (780) 421-3363

>

> "Desire is the starting point of all achievements. Not hope; not wish, 

> but a keen pulsating desire which transcends everything."

>

> CONFIDENTIALITY CAUTION:  This message is intended only for the use of 

> the individual or entity to which it has been addressed and may 

> contain information that is privileged and confidential.  If you are 

> not the intended recipient, or the employee or agent responsible for 

> delivering the message to the intended recipient, you are hereby 

> notified that any dissemination, distribution or copying of this 

> communication is strictly prohibited.  If this communication has been 

> received in error, respond immediately via telephone or return e-mail, 

> and delete all copies of this material.

>

>  





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel W. Fink
  INET: optimaldba_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).