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

From: <>
Date: Mon, 14 Apr 2003 12:38:59 -0800
Message-ID: <>

Again, stress-test before going into production makes it easier - less of an issue of the developer having to save-face and more happy to make changes and more time for the dBA to "prove" their theory.  

Oracle OCP DBA

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

In the typical smokestack-organized business, it's kind of like playing volleyball in a just-for-fun recreational league... A lot of balls hit the floor to the sounds of "YOU GOT IT!" SQL efficiency is common ball to drop unattended.  

Hypothetically, the developers should be responsible for the efficiency of their code (not its overall performance, but its efficiency). However, this is often not the case. Many times, the DBA is the first person to get "blamed" for poor performance, and the DBA is thus often the first person to find out that a query returning a three-row result set does its work by visiting 3,000,000,000 database blocks in the database buffer cache. Sometimes the most frustrating part of the job is even to convince a developer that there actually even *is* a problem. And of course there's no more effective way to do that than to rewrite the query so it returns the same 3 rows with just 42 LIOs.  

It still amazes me how often that, even after doing this, a developer will grumble something like, "Well if the database were better managed, then I wouldn't have to put up with requests like this to 'tune my code.'" *That's* when you have to look really deep inside yourself and decide how you feel about corporal punishment.  

Cary Millsap
Hotsos Enterprises, Ltd. <>

Upcoming events:
- Hotsos <> Clinic 101 in London,
Reykjavik, Ottawa, Denver, Sydney
- Visit <> for schedule details...

-----Original Message-----
(Do Not Use)
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 - 15:38:59 CDT

Original text of this message