Re: Tuning unknown applications

Yes...:)))...guilty as charged...that was done 11 years ago. Boy, time flies!
 Gaja Krishna Vaidyanatha,
Founder/Principal, DBPerfMan LLC
http://www.dbperfman.com
Phone - 001-(650)-743-6060
Co-author:Oracle Insights:Tales of the Oak Table - 
http://www.apress.com/book/bookDisplay.html?bID=314
Co-author:Oracle Performance Tuning 101 - 
http://www.amazon.com/gp/reader/0072131454/ref=sib_dp_pt/102-6130796-4625766




________________________________
From: Tim Gorman <tim_at_evdbt.com>
To: oracle-l <oracle-l_at_freelists.org>
Sent: Wed, March 23, 2011 4:12:22 PM
Subject: Re: Tuning unknown applications

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@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

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