Re: Trace Analyzer - Wow

:-) Awesome.

Latency hiding in the spirit of
http://carymillsap.blogspot.com/search?q=latency+hiding.


Cary Millsap


On Tue, Nov 24, 2009 at 10:19 PM, <troach@xxxxxxxxx> wrote:

> Speaking of wait time. I am in Florida for the thanksgiving holiday and I
> went to eat at a hole in the wall place. On the wall it said "burger wait
> time: 1 1/2 beers" :).
>
> Sent from my Verizon Wireless BlackBerry
> ------------------------------
> *From: * Cary Millsap <cary.millsap@xxxxxxxxxxxx>
> *Date: *Tue, 24 Nov 2009 22:15:11 -0600
> *To: *<dannorris@xxxxxxxxxxxxx>
> *Cc: *<troach@xxxxxxxxx>; <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>;
> oracle-l@xxxxxxxxxxxxx<oracle-l@xxxxxxxxxxxxx>
> *Subject: *Re: Trace Analyzer - Wow
>
> 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@xxxxxxxxxxxxx>wrote:
>
>> Hotsos Profiler -> Method R Profiler now.
>> http://method-r.com/software/profiler
>>
>>
>> On Tue, Nov 24, 2009 at 2:58 PM, <troach@xxxxxxxxx> 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@xxxxxxxxxxxxxxx>
>>> *Date: *Tue, 24 Nov 2009 14:51:50 -0600
>>> *To: *'oracle-l@xxxxxxxxxxxxx'<oracle-l@xxxxxxxxxxxxx>
>>> *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@xxxxxxxxxxxxxxx
>>>
>>>
>>>
>>> *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.*
>>>
>>
>>
>

Other related posts: