Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: formating 10046 (level 12) trace file

Re: formating 10046 (level 12) trace file

From: Paul Vallee <dbalist_at_pythian.com>
Date: Wed, 08 May 2002 08:52:24 -0800
Message-ID: <F001.0045B99C.20020508085224@fatcity.com>


You can also look up George Schlossnagle's excellent "trace2perl" utility on freshmeat.net.
HTH,
Paul

---
www.pythian.com -- vallee_at_pythian.com -- 877-PYTHIAN
Smarter than adding another team member, Pythian has new services for
supplementing DBAs: get our help with monitoring, 24x7 on-call, daily
verifications, storage management, performance and more.

----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Wednesday, May 08, 2002 11:58 AM


I very much appreciate these programs being offered for free. I really
appreciate the people who have blazed the trail in this area and well feel
they deserve success.
However, I am curious whether anyone has tried to create their own with Perl
(or similar tool)?
Just put me down as more of a "do-it-yourselfer".
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com


-----Original Message-----
Sent: Tuesday, May 07, 2002 8:13 PM
To: Multiple recipients of list ORACLE-L


Mohammed,

You can look at 2 known options :-

1) The Hotsos Profiler at
http://www.hotsos.com/products/profiler/

2) ITRProf on http://www.ubtools.com/main.html

Hope that helps,

Gaja

--- Mohammed.Ahsanuddin_at_VerizonWireless.com wrote:

> Hello,
>
> I was wondering if there is any tool or script which
> can get the SQL and its
> associated bind values from 10046 (level 12) trace
> file and format it in a
> readable way..
>
> Any hints will be highly appreciated..
>
> Thanks in advance.
>
> Mohammed Ahsanuddin
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: Mohammed.Ahsanuddin_at_VerizonWireless.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> 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).
===== Gaja Krishna Vaidyanatha Director, Storage Management Products, Quest Software, Inc. Co-author - Oracle Performance Tuning 101 http://www.osborne.com/database_erp/0072131454/0072131454.shtml __________________________________________________ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gaja Krishna Vaidyanatha INET: oraperfman_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: Paul Vallee INET: dbalist_at_pythian.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
Received on Wed May 08 2002 - 11:52:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US