Re: Tuning unknown applications

From: Tim Gorman <tim_at_evdbt.com>
Date: Wed, 23 Mar 2011 17:12:22 -0600
Message-ID: <4D8A7E56.1070708_at_evdbt.com>

No, CTD was coined and described by Mr. Gaja Vaidyanatha...

On 3/23/2011 4:29 PM, Stephens, Chris wrote:
> Beware of ctd (compulsive tuning disorder).
>
> Was it you that coined the term tim?
>
> There are days when I look at what is running inside the databases here and feel like I need to look at\rewrite everything. Then there are days when I start with...“what needs improving and what doesn't“. Those days end much better.
>
> Chris
>
> ----- Original Message -----
> From: Tim Gorman [mailto:tim_at_evdbt.com]
> Sent: Wednesday, March 23, 2011 05:19 PM
> To: oracle-l_at_freelists.org<oracle-l_at_freelists.org>
> Subject: Re: Tuning unknown applications
>
> Don't bother learning the application, focus on what the users say is
> hurting them. Step #1) look for the SQL statements taking tons of
> elapsed-time or response-time, #2) focus on the worst two or three SQL
> statements, #3) fix them, #4) implement the fix in production, and #5)
> repeat all over again starting from step #1.
>
> Best to use SQL tracing on specific programs identified by users as
> performing poorly. Check out white papers on www.method-r.com on tuning
> methodology and consider buying the book "Optimizing Oracle Performance"
> by Millsap and Holt (O'Reilly, 2003).
>
>
>
>
> On 3/23/2011 3:44 PM, Ram Raman wrote:
>> List,
>> When DBAs are put in charge of unknown applications not developed in
>> house or put in charge of third party COTS applications, how do we go
>> about learning the systems and tune such systems. This is an open
>> ended question, but when I am asked to tune things, I am not sure how
>> I would start without knowing the processes and data structure.
>> Thanks.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 23 2011 - 18:12:22 CDT