RE: slightly OT: another free oracle resource profiler

I would like to get our developers looking at trace files, but I can't even get them to look at the sanitized tkprof output (via a handy PL/SQL package), 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 output to a webpage for them and e-mail the URL...

TIA!
Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_quadtechworld.com      QuadTech, Sussex, WI USA

-----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

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

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

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 :-)

--

http://www.freelists.org/webpage/oracle-l Received on Thu Apr 28 2005 - 10:10:11 CDT