RE: scripts to parse oracle 10046 trace files?
- From: <rajendra.pande@xxxxxxx>
- To: <oracledbaquestions@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 5 Mar 2012 11:59:11 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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?
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
