RE: scripts to parse oracle 10046 trace files?
Date: Mon, 5 Mar 2012 12:04:56 -0500
One other to try is :
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
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?
NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to www.td.com/legal for instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié. Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière d'aller au www.td.com/francais/avis_juridique pour des instructions.
http://www.freelists.org/webpage/oracle-l Received on Mon Mar 05 2012 - 11:04:56 CST