Message-ID: <F001.005D1149.20030925133941@fatcity.com>
Date: Thu, 25 Sep 2003 13:39:41 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Daniel Fink <Daniel.Fink@Sun.COM>
Subject: Re: any else try trace analyzer?
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-type: multipart/mixed; boundary=------------22C23A0547D28AAB20F56043
--------------22C23A0547D28AAB20F56043
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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@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@cox.net
>   INET: rgaffuri@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@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).

--------------22C23A0547D28AAB20F56043
Content-Type: text/x-vcard; charset=us-ascii;
 name="daniel.fink.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Daniel Fink
Content-Disposition: attachment;
 filename="daniel.fink.vcf"

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

--------------22C23A0547D28AAB20F56043--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Fink
  INET: Daniel.Fink@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@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).