Re: script to parse 10046 trace files
- From: Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Sep 2011 10:06:24 +0200
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@xxxxxxxxxxxxxxxxxxx
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@xxxxxxxxx>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.
>>
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Pole nakazi
----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
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--
//www.freelists.org/webpage/oracle-l
Other related posts:
