Re: slightly OT: another free oracle resource profiler

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 28 Apr 2005 16:00:41 +0100
Message-ID: <7765c89705042808003fbc03e3@mail.gmail.com>

I'm aware of=20

hotsos                        www.hotsos.com - paid for perl
orasrp                        oracledba.ru/orasrp/ - free source
available python
SimpleProfiler           =20

www.niall.litchfield.dial.pipex.com/SimpleProfiler/SimpleProfiler.html (pl/sql)=20

traceanalyzer metalink.oracle.com=20

On 4/28/05, Jesse, Rich <Rich.Jesse_at_quadtechworld.com> wrote:
> I would like to get our developers looking at trace files, but I can't ev=
en get them to look at the sanitized tkprof output (via a handy PL/SQL pack= age), much less try to decipher/understand the raw trace.
> Has anyone compiled a list of trace profilers? I'd need the name (duh), =
website, and cost. I'm thinking maybe I could have my package push the out= put to a webpage for them and e-mail the URL...

>=20

> TIA!
> Rich

>=20


> Rich Jesse                        System/Database Administrator

> rich.jesse_at_quadtechworld.com      QuadTech, Sussex, WI USA

>=20
>=20

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> Sent: Wednesday, April 27, 2005 6:45 PM
> Subject: Re: slightly OT: another free oracle resource profiler

>=20

> I have to admit, when processing trace files, I've rarely found the
> need to go much more sophisticated then (in pseudo-code)

>=20

> 10046 level 8 | tkprof | grep ^total | sort | head -3

>=20

> Don't get me wrong - I've been really impressed with the hotsos
> profiler, orasrp and the like, but it ain't normally that hard to find
> the worst piece of code in a system :-)

>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

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

Received on Thu Apr 28 2005 - 11:05:41 CDT