script to parse 10046 trace files
From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Tue, 20 Sep 2011 11:46:26 -0400
Message-ID: <CAE-dsOLhpAEX=zkOWX4X50r=CKs1mK36KBZto9pTK-Mcaqw-ww_at_mail.gmail.com>
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.
Date: Tue, 20 Sep 2011 11:46:26 -0400
Message-ID: <CAE-dsOLhpAEX=zkOWX4X50r=CKs1mK36KBZto9pTK-Mcaqw-ww_at_mail.gmail.com>
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-lReceived on Tue Sep 20 2011 - 10:46:26 CDT