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

[EMAIL PROTECTED] 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: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
begin:vcard 
n:Fink;Daniel
x-mozilla-html:FALSE
org:Sun Microsystems, Inc.
adr:;;;;;;
version:2.1
title:Lead, Database Services
x-mozilla-cpt:;9168
fn:Daniel  W. Fink
end:vcard

Reply via email to