| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBA's that tune duhveloper's SQL
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-----
Sent: Monday, April 14, 2003 1:24 PM
To: Multiple recipients of list ORACLE-L
deborah,
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:)
Raj
-----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: Burke, William F (Bill) INET: wbburke_at_avaya.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 - 14:29:07 CDT
 |
 |