Oracle-L: RE: DBA's that tune duhveloper's SQL

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Mon, 14 Apr 2003 10:23:56 -0800
Message-ID: <F001.00580956.20030414102356@fatcity.com>

deborah,

We usually perform,

SQL Tuning (at the express request of Development)
pl/sql tuning (ditto)
when we find spinner processes we do a voluntary code scan, give helpful suggestions to development. Development can say NO, but if we prove the benefits, they can't refuse (the later part of the rule is being worked out so it can be implemented soon).

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

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 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. ; )

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.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).



text/plain attachment: ESPN_Disclaimer.txt

Received on Mon Apr 14 2003 - 13:23:56 CDT