Re: response time resource profile ?!

Prem,

You can download Oracle Trace Analyzer from Metalink. It's a decent tool, relying on sql & pl/sql to read and parse the trace file. The reports that are output are kind of 'noisy' and very long. It cannot handle large trace files and it does not handle 'similar' sql statements (same statement except for literal values) well.

Daniel

Prem Khanna J wrote:
> Hi all,
> i am using oracle 9.2.0.4.
>
> how to prepare response time resource profile from a trace file ?
>
> Any other way of doing it without using Hotsos profiler !
>
> There is a PERL script in cary's book , which has got some
> limitation as he himself had mentioned.
>
> Any help would be greatly appreciated .
>
> Regards,
> Prem.
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l