Is there a commercial tool that will do the same thing
as the tool from hotsos? I am sort of angry with oracle
for not providing such tool to all of it's users. I'm more
inclined to test my abilities as a DBA (and those have been put to
test once or twice) then to pay $50/month to a 3rd party company
whose only advantage is that it has access to the information
and the tool that I do not have. If the information was available
to me, I could have used a little bit of flex/bison in conjunction
with OCI to write such a thing.
If I have to buy the tool, so be it, but then I want to use it
whenever I want, without the monthly fee. This, with all due respect
looks like milking a gullible cash cow and, with all due respect, I
don't like that.
I think that oracle should make public the information needed for such a
tool so that the rest of us who know how to put together a yacc grammar
can at least take a shot at writing such a tool.
> -----Original Message-----
> From: Gaja Krishna Vaidyanatha [mailto:oraperfman_at_yahoo.com]
> Sent: Tuesday, May 07, 2002 9:13 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: formating 10046 (level 12) trace file
>
>
> 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: Gogala, Mladen
INET: MGogala_at_oxhp.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:08:53 CDT
