> "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."
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.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: sfaroult_at_oriole.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).
Received on Mon Apr 14 2003 - 15:13:42 CDT
