script to parse 10046 trace files
- From: Dba DBA <oracledbaquestions@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Sep 2011 11:46:26 -0400
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
