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: Burke, William F (Bill) <>
Date: Mon, 14 Apr 2003 11:29:07 -0800
Message-ID: <>

It is really gonna depend on the shop. In some shops, adequate testing and qa databases are not available to accurately determine execution paths and tuning options. In these shops (like mine), I inherit what I get. They do the best they can with minimal development environments, but issues such as partitioning or any other advanced storage management or tuning is not even remotely considered. In particular if you have developers who are working in java, with some transport layer in-between, it actually makes it even more difficult for them. Years ago, as a developer, production NEVER had to tune or address code I/we sent in for migration. Today, the role/environment is changing and many of the best DBA's, also used to be developers so have a natural tendency towards tuning, and, may even enjoy it (I do). In short, if you're seeing the need/requirement to tune code after it's migrated to production, relying and utilizing best in breed tuning software for capture and lab tuning on the fly is essential. Personally, I trap the worst sql which ran during the day (only one) and focus on providing tuning help on that one as appropriate.  

Even as a production DBA, that's good practice, because in the best of circumstances, your database will mature and evolve and not look like what the developers coded against, so it becomes you're responsibility to handle maturity tuning as I call it. Not to mention being a good sql and code tuner will never hurt your resume' ;)  

HTH Regards,

Bill Burke
"The Kinder and Gentler DBA" International Oracle Users Group Board of Directors Elect - 2003-2005
Board of Directors - 2000-2002
University Master Class Faculty 2001-2002 Oracle Development Tools User Group Board of Directors 1996-2000

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


We usually perform,  

I don't suppose tuning is a responsibility is DBAs, development staff should do initial tuning, optimizing their code. DBAs usually get involved at later stages.  

But, doing investigative work shouldn't be new for you ... looking at your place of work 8:)

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
Sent: Monday, April 14, 2003 1: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. ; )  

Please see the official ORACLE-L FAQ:
Author: Burke, William F (Bill)

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:29:07 CDT

Original text of this message