RE: formatting 10046 (level 12) trace file

I'm afraid that I must agree with Tim. I have never worked for Oracle, and other DBA's that I know out there who manage to ferret out this information without Oracle's help.

Actually, you will find some of this stuff in the documentation, other in various books, but I think the best stuff is found on web sites like ixora.com.au, as an example. Metalink often can be revealing if you use it right, as can technet.

I have griped in the past about some of Oracle's "close to the vest" attitude, and it can be frustrating... and I think they have forgotten what customer service is of late (they need Ray Lane back!). Still, people have figured this stuff out, it just takes some time and effort.

Besides, who can blame Oracle for wanting to make a buck. If they can still sell product and do the other things they do, more power to 'em..... but, I think they will have to have a change of attitude or Mr. Gates and IBM are going to be eating into their market share more and more.

Oracle and Larry, are you listening?

RF
capitalism
-----Original Message-----
Sent: Wednesday, May 08, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: Robert_Freeman_at_csx.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).