Re: Latency Histogram from 10046 trace
From: Dion Cho <ukja.dion_at_gmail.com>
Date: Tue, 27 Oct 2009 09:18:21 +0900
Message-ID: <43c2e3d60910261718g78516678y904188bb24a26bff_at_mail.gmail.com>
I don't have a matching example but I would like a pure Oracle-based solution.
Dion Cho - Oracle Performance Storyteller
Date: Tue, 27 Oct 2009 09:18:21 +0900
Message-ID: <43c2e3d60910261718g78516678y904188bb24a26bff_at_mail.gmail.com>
I don't have a matching example but I would like a pure Oracle-based solution.
- Create a directory object on the trace file folder.
- Declare a table function which reads the trace file line by line and returns the array of the lines.
- Apply regular expressions on the lines returned by 2 and do aggregation.
Some simple examples:
http://dioncho.wordpress.com/page/5/?s=get_trace_file http://dioncho.wordpress.com/page/2/?s=get_trace_file http://dioncho.wordpress.com/page/3/?s=get_trace_file http://sites.google.com/site/ukja/sql-scripts-1/c/get_trace_file
Sorry that it's not a working UNIX shell script. :)
Dion Cho - Oracle Performance Storyteller
http://dioncho.wordpress.com (english) http://ukja.tistory.com (korean) http://dioncho.blogspot.com (japanese) http://ask.ex-em.com (q&a) ================================
2009/10/27 K Gopalakrishnan <kaygopal_at_gmail.com>
>
> Guys,
>
> I am looking for some UNIX help here. I have a huge 10046 trace and trying
> to create a histogram for wait times. (something like V$event_histogram from
> trace file).
> Anyone has any working examples?
>
>
> Best Regards,
> K Gopalakrishnan
>
> Oracle Database 10g Real Application Clusters Handbook
> http://www.amazon.com/gp/product/007146509X/
>
> Oracle Wait Interface: A Practical Guide to Performance Diagnostics &
> Tuning
> http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 26 2009 - 19:18:21 CDT