RE: scripts to parse oracle 10046 trace files?

From: <rajendra.pande_at_ubs.com>
Date: Mon, 5 Mar 2012 11:59:11 -0500
Message-ID: <D4C8B99EB96F2C42B4E19A3B87664F5E0335E82B_at_NSTMC612PEX.ubsamericas.net>



Have you looked at http://dominicgiles.com/traceanalyzer.html Else you are asking to get something like Method-R :)

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dba DBA Sent: Monday, March 05, 2012 11:42 AM
To: ORACLE-L
Subject: scripts to parse oracle 10046 trace files?

I am looking for scripts people have on the internet. I know about the hotsos application. I am primarily looking for scripts to parse 10046 traces that do more than tkprof. One issue with tkprof is that I can't see
the explain plan and the row source by row source logical and physical IOs
until the query is done. Before I go off and write my own scripts I was wondering if there are any on that either do the following (or anything else useful that I am not thinking of).
-- can generate an explain plan with row source by row source metrics on
a
sql that is already running.
-- can sum up the events, timings, number of blocks hit ,etc.. for a
query
that is still running. So I can generate reports while long running queries
are still running
-- can pull out bind variables from trace files for each sql.

  • does the trace file have the sql_id or hash_value? I have not been able to find it.
  • anything else that you find useful.

I would be interested in scripts that parse other oracle trace files just
so I can see what people are doing.

I have one other question that is slightly off topic, but I didn't want to
send too many emails. Is there a good way to trace a query that using run
using a parallel hint? This opens up multiple sessions. So if I trace my current session, I only get my current session. I can trace these other session, but it will be after the query starts. anyway to trace all the parallel slaves from the moment they start without turning on tracing for
the whole database?

--

http://www.freelists.org/webpage/oracle-l

Please visit our website at
http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html for important disclosures and information about our e-mail policies. For your protection, please do not transmit orders or instructions by e-mail or include account numbers, Social Security numbers, credit card numbers, passwords, or other personal information.
--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 05 2012 - 10:59:11 CST

Original text of this message