Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBA's that tune duhveloper's SQL

RE: DBA's that tune duhveloper's SQL

Date: Mon, 14 Apr 2003 11:37:35 -0800
Message-ID: <>


    I think it is easy for somebody to make a statement like this which sends us into a panic. Sometimes the difference between a good DBA and a poor one is that a good DBA can reply in terms that a manager can understand. Do a quick review of how many SQL statements per week times the average tuning time and your manager starts seeing that another person might need to be hired. Or propose a policy that will ensure no new code is implemented without a SQL review by yourself. Now your manager starts seeing that negotiation would be needed with the various development groups. A poor DBA panics at the prospect of being forced to give up more personal time off. I can't say I've achieved the good DBA status yet, but I feel I'm on the path to enlightenment.

     Another thing to consider is that the applications tend to vary widely. We have used client-server development tools that help the developers create good code, so haven't had many problems. Now we are moving into the brave new world of Java and EJBs and J2EE code, and I am concerned whether this will produce more bad SQL. Reports tend to produce more tuning problems.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.

-----Original Message-----
Sent: Monday, April 14, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L

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 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:


Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (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). Received on Mon Apr 14 2003 - 14:37:35 CDT

Original text of this message