Re: script to parse 10046 trace files
From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Wed, 21 Sep 2011 10:06:24 +0200
Message-ID: <4E799B00.9080903_at_nordea.com>
I would recommend a tool with name trace_report.sh (do not remeber the author and location - just google for it) - this is much better then tkprof and the only from 3rd party tools, which was able to process 4G trace file (and btw. is is written in awk :-)) and I think it is really fast
>> 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
>>
>>
>>
Date: Wed, 21 Sep 2011 10:06:24 +0200
Message-ID: <4E799B00.9080903_at_nordea.com>
I would recommend a tool with name trace_report.sh (do not remeber the author and location - just google for it) - this is much better then tkprof and the only from 3rd party tools, which was able to process 4G trace file (and btw. is is written in awk :-)) and I think it is really fast
I found it:
http://www.dbasolutionsinc.com/downloads.php
by Brian Lomasky lomasky_at_dbasolutionsinc.com
Regards
Remigiusz
W dniu 21.09.2011 05:21, Madhu Sreeram pisze:
> 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 > > >
-- Pole nakazi ---------------------------------------------------------------------- Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com> pos : DBA at DIiUSI addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland phone : +48 58 667 17 43 mobile: +48 602 42 42 77 Nordea Bank Polska S.A. z siedziba w Gdyni, ul. Kielecka 2, 81-303 Gdynia, wpisana do Rejestru Przedsiebiorców Krajowego Rejestru Sadowego pod numerem: 0000021828, dla której dokumentacje przechowuje Sad Rejonowy Gdansk - Pólnoc w Gdansku, VIII Wydzial Gospodarczy Krajowego Rejestru Sadowego, o kapitale zakladowym i wplaconym w wysokosci: 277.493.500,00 zlotych, NIP: 586-000-78-20, REGON: 190024711-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 21 2011 - 03:06:24 CDT