I'm not talking about secret passwords, I'm taking
about the format of a trace file which is not documented
anywhere and the interpretation of all those wait events.
I believe that his documentation is only available to those
who are (or were) working for oracle. I agree about the
compensation, I have no problem with that, that is why I am
asking for the information which would enable me to write such
a program, not about the program itself. Normally, compensation
for a program is achieved by selling the program, as with Oracle
RDBMS. If I buy oracle database, I'm not charged for a monthly
usage and the software resides on my machine.
I've already done the same thing with conversion from
Sqlforms 2.3 -> Forms 3.0. It was a month worth of flex & bison
getting all those "success steps" and "failure steps"
rewritten as "if then else" constructs in PL/SQL. The company that
was selling that stuff was trying to charge PER TRIGGER! No way in....
The same logic applies here. If they're selling the tool, that's OK,
but I'm not willing to be charged for service. I want to have the tool
and the documentation available on my machine whenever I like it.
They're great consultants, and they are attempting to establish themselves
as an online service provider (the same, I believe, is the case with
Jenna Jameson's web site) but I started my career on RSX and KED and
assembling NCP for 3084, which means that I have different ideas about
software sales. After all, I've Been Mugged with IMS, CICS DL/I and alike
much before Oracle.
> -----Original Message-----
> From: Tim Gorman [mailto:Tim_at_SageLogix.com]
> Sent: Wednesday, May 08, 2002 1:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: formating 10046 (level 12) trace file
>
>
> Mladen,
>
> The people who put those tools together (at Hotsos and
> UBTools) did not
> "receive secret information" or "have access to information"
> or use some
> other shortcut not available to you. Rather, they exhaustively and
> laboriously researched the mechanisms involved to develop these tools.
> These tools are the result of a tremendous amount of effort
> on their part:
> research, observation, testing, and persistence (often "after
> hours"). They
> have doubtlessly shared these tools for free with friends and
> colleagues,
> but like anyone else, they deserve compensation if someone
> (not a friend or
> colleague) is going to make use of efforts. That's just the
> way the world
> works.
>
> I was speaking to a CIO recently who said, "Hey, there's no
> magic in this
> stuff. I can write SQL too!". Yup, but is that how you want
> to spend your
> time and can you really do all the other stuff that comes
> with creating
> tuned applications? Consider the "build-vs-buy" aspects as well...
>
> Oracle Corporation protects its intellectual property quite
> vigorously, but
> even they cannot stop someone from "reverse-engineering" in order to
> understand the mechanisms. Nobody at Hotsos or UBTools has
> secret passwords
> (Oracle Legal would freak out!). Only inspiration, a good network of
> talented friends, and a helluva work ethic...
>
> ...just my $0.02...
>
> -Tim
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, May 08, 2002 10:08 AM
>
>
> > 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tim Gorman
> INET: Tim_at_SageLogix.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 - 15:53:25 CDT
