Re: Tuning unknown applications
- From: "Stephens, Chris" <Chris.Stephens@xxxxxxx>
- To: "'tim@xxxxxxxxx'" <tim@xxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Mar 2011 17:29:44 -0500
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
CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is privileged,
confidential and exempt from disclosure under applicable law. If the reader of
this message is not the intended recipient or the employee or agent responsible
for delivering this message to the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this communication is
strictly prohibited. If you have received this communication in error, please
notify us immediately by email reply.
Other related posts:
