Re: any else try trace analyzer?

I've done a little with it. It's free, which is a plus and it parses the trace file and loads it into database tables. The documentation is limited to a single readme, which is adequate. The biggest problems with it are that it requires you to run the analyzer as the user issuing the query, it is very slow if the trace file is large, it consumes space inside the database, it suffers from the same problem as tkprof where it reports the explain plan as if you were running the statement now and not how it actually ran.

It is well ahead of tkprof in many respects (until 9i), but it is not as good as the Hotsos Profiler.

Dan

rgaffuri_at_cox.net wrote:

> Looks to be pretty new. I think it came from the Apps team. Its not even in Kytes new book.
>
> you can get it off of metalink. It gives you alot more info than tkprof when teamed with a 10046 trace.
>
> any articles on this yet? There is some data in it, I cant quite follow?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <rgaffuri_at_cox.net
> INET: rgaffuri_at_cox.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Fink
  INET: Daniel.Fink_at_Sun.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



text/x-vcard attachment: Card for Daniel Fink