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.* >