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: Stephane Faroult <>
Date: Mon, 14 Apr 2003 12:13:42 -0800
Message-ID: <>

> "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 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."

What I usually see is, after a crisis, people coming to a DBA asking for database tuning - the magical init.ora parameter. More advanced users may ask for a review of indexing - DBA job, isn't it. Some dangerous users (consultants, usually) may even come with technical solutions of their own (partitioning DUAL, etc.). At which point a DBA who knows the job is quick to find the statement of death, and make the 55,000+ seconds query run in 8 seconds (an example from last week). In other words, SQL tuning is a bit of an accident. I personally find it unfortunate that, for mainly historical reasons, tuning has always been considered a topic for DBAs (and mostly senior ones) and people considered at various degrees to be experts. I believe that there should be a lot to be gained teaching people having between 2 and 5 years of development experience - who are past the simple problem of finding the query which returns the correct result set - even if it were only to look for the advice of others.


Stephane Faroult
Oriole Software
Please see the official ORACLE-L FAQ:
Author: Stephane Faroult

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:13:42 CDT

Original text of this message