Re: Tuning unknown applications
- From: Gaja Krishna Vaidyanatha <gajav@xxxxxxxxx>
- To: Oracle-L List <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Mar 2011 20:51:46 -0700 (PDT)
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@xxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx]
> Sent: Wednesday, March 23, 2011 05:19 PM
> To: oracle-l@xxxxxxxxxxxxx<oracle-l@xxxxxxxxxxxxx>
> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
