Re: slightly OT: another free oracle resource profiler
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: Rich.Jesse@xxxxxxxxxxxxxxxxx
- Date: Thu, 28 Apr 2005 16:00:41 +0100
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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
>=20
>=20
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> 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
> --
> //www.freelists.org/webpage/oracle-l
>=20
--=20
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
