RE: script to parse 10046 trace files
Date: Tue, 20 Sep 2011 18:46:52 +0200
Message-ID: <4814386347E41145AAE79139EAA398981511B67D58_at_ws03-exch07.iconos.be>
I sometimes use orasrp, which I quite like. But it will not show you the physical / logical io per row source.
However, have you considered to use the dbms_xplan in combination with the /*+ gather_plan_statistics */ statistics hint? It will not show you the actual io, but it will show the actual number of rows, which in my opinion is even better for checking if a query plan is optimal or not.
If you are on 11g you can have a look at sql monitor, but I think you will need the tuning pack (and thus the diagnostic pack) for this.
Kind regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dba DBA
Sent: dinsdag 20 september 2011 17:46
To: ORACLE-L
Subject: script to parse 10046 trace files
I know their are vendors (like hotsos), that have products you can buy. The
company I work for is not going to buy a product. Anyone have anything more
advanced than tkrpof? Preferably one that will generate an explain plan with
the logical and physical IO by row source (action in the explain plan)
without the query completing. We have some very complex queries. The easiest
way for me to analyze a query is with a tkprof since I can see what parts of
the query are using the most logical and physical IO. I don't want to let a
query run and run to wait for it to complete.
I do read the raw trace file and it is helpful up to a point. However, a
script to create a summary report similiar to tkprof would be very useful or
anything else someone might have.
I have thought about writing my own. I would probably use awk. However,
before I do that, I was wondering if there are any out there already? Even
if you don't have one that does what i am looking for, I would be interested
to see what is out there. I did a few google searches and I didn't find
anything.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 20 2011 - 11:46:52 CDT