Re: Trace Analyzer - Wow

From: Cary Millsap <cary.millsap_at_method-r.com>
Date: Tue, 24 Nov 2009 22:15:11 -0600
Message-ID: <3a2a84fc0911242015r2340abdk2ea37235fa45cf9f_at_mail.gmail.com>



Method R Profiler also reports on bind variable substitution values. It doesn't report on *all* the values that were used, only the sets of substitution values that drive the best-case and worst-case performance for a given statement. The goal is that the worst-case substitution value set shows you the problem you need to work on first, and the best-case substitution value set shows you how well the statement should be able to perform.

Trace analyzer is much nicer than tkprof, but it still doesn't meet the principal design criterion of the Method R Profiler, which is to illuminate where *all* your business task's response time has gone, whether your problem is inefficient SQL or something else (which these days it often is). There are several types of response time problems that tkprof and trcanlzr don't go very far in helping you solve. The Method R Profiler has a * considerable* speed advantage over trcanlzr as well.

For more information, see http://method-r.com/software/profiler, as Dan previously noted.

A former colleague at Hotsos has asked me to bring to your attention that they also sell licenses for our Method R Profiler under the Hotsos Profiler brand name. I am no longer affiliated with Hotsos, so I hope that if you're interested in the product, you'll contact me directly.

Cary Millsap
Method R Corporation

http://method-r.com
http://carymillsap.blogspot.com
http://twitter.com/cary_millsap


On Tue, Nov 24, 2009 at 4:20 PM, Dan Norris <dannorris_at_dannorris.com> wrote:

> Hotsos Profiler -> Method R Profiler now.
> http://method-r.com/software/profiler
>
>
> On Tue, Nov 24, 2009 at 2:58 PM, <troach_at_gmail.com> wrote:
>
>> I've used it. Carlos Sierra did a great job in writing it.
>>
>> I also like orasrp and the tool from Chris Antognini. Not to be outdone,
>> the hotsos profiler is very good as well. All beat tkprof imo.
>>
>> Sent from my Verizon Wireless BlackBerry
>> ------------------------------
>> *From: * "Taylor, Chris David" <ChrisDavid.Taylor_at_ingrambarge.com>
>> *Date: *Tue, 24 Nov 2009 14:51:50 -0600
>> *To: *'oracle-l_at_freelists.org'<oracle-l_at_freelists.org>
>> *Subject: *Trace Analyzer - Wow
>>
>> Any of you guys/gals use TRCANLZR to analyze sql statements? I just
>> used it for the first time today, and Iím impressed.
>>
>>
>>
>> I typically use tkprof on the trace files to dig through a poor performing
>> query, but trace analyzer blows it away.
>>
>>
>>
>> Oracle outdid themselves on this tool I think.
>>
>>
>>
>> ONE of the best thing about it, is it gives you the bind values from the
>> trace file for the query in question.
>>
>>
>>
>>
>>
>>
>>
>> *Chris Taylor*
>>
>> *Sr. Oracle DBA*
>>
>> Ingram Barge Company
>>
>> Nashville, TN 37205
>>
>> Office: 615-517-3355
>>
>> Cell: 615-354-4799
>>
>> Email: chris.taylor_at_ingrambarge.com
>>
>>
>>
>> *CONFIDENTIALITY NOTICE**: This e-mail and any attachments are
>> confidential and may also be privileged. If you are not the named recipient,
>> please notify the sender immediately and delete the contents of this message
>> without disclosing the contents to anyone, using them for any purpose, or
>> storing or copying the information on any medium.*
>>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 24 2009 - 22:15:11 CST

Original text of this message