Re: script to parse 10046 trace files

From: Madhu Sreeram <madhusreeram_at_gmail.com>
Date: Tue, 20 Sep 2011 22:21:50 -0500
Message-ID: <CAPZqL6EEjxvUF068Ps3hH_QNhgM7KFLekEpuKOystfnZtmZSnA_at_mail.gmail.com>

You may want to check out the oracle tool TRCANLZR * [ID 224270.1]* that I have found very useful. You basically run a script using sqlplus - as simple as that. It generates a html report with nice formatting and sorting. I don't remember if it has what you are looking for, but that is best you get, direct from oracle.
-Madhu

On Tue, Sep 20, 2011 at 10:46 AM, Dba DBA <oracledbaquestions_at_gmail.com>wrote:

> 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 - 22:21:50 CDT