Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DBA's that tune duhveloper's SQL

Re: DBA's that tune duhveloper's SQL

From: Joe Testa <jtesta_at_dmc-it.com>
Date: Tue, 15 Apr 2003 17:18:53 -0800
Message-ID: <F001.0058217A.20030415171853@fatcity.com>


Bill, avaya.com?

I'm at Safelite Corp and they're implementing Avaya stuff(CTI).

same stuff?

joe

Burke, William F (Bill) wrote:

> 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" www.OracleGuru.com
> *International Oracle Users Group* www.ioug.org
> Board of Directors Elect - 2003-2005
> Board of Directors - 2000-2002
> University Master Class Faculty 2001-2002
> *Oracle Development Tools User Group* www.odtug.com
> Board of Directors 1996-2000
>
> -----Original Message-----
> *From:* Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com]
> *Sent:* Monday, April 14, 2003 1:24 PM
> *To:* Multiple recipients of list ORACLE-L
> *Subject:* RE: DBA's that tune duhveloper's SQL
>
> 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-----
> *From:* IT - Database (Do Not Use)
> [mailto:dbamail_at_police.edmonton.ab.ca]
> *Sent:* Monday, April 14, 2003 1:29 PM
> *To:* Multiple recipients of list ORACLE-L
> *Subject:* DBA's that tune duhveloper's SQL
>
> 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. ; )
>
>

-- 
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.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 Tue Apr 15 2003 - 20:18:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US