Glenn Fawcett's Weblog

"orasrp" - Free Oracle response time based trace profiler.

Tuesday Jun 21, 2005

Ever since I started reading the "Optimizing Oracle Performance" book by Cary Millsap, I have been salivating over getting a copy of the Hotsos profiler - but alas it is too expensive. Recently I tried to find a copy of their free version "Sparky" but it had been pulled due to support issues.

Finally, I stumbled upon orasrp. This analyzer is written in python and can be used standalone to produce html, or you can browse a directory of trace files via your web browser.

[3] Comments
Like this post? del.icio.us | furl | slashdot | technorati | digg
Posted at 10:51AM Jun 21, 2005 by glennf in Oracle
Tags:
Comments:

I downloaded orasrp. Am a tkprof newbie and I think orasrp is just great. I was analyzing an update statement (which creates an intermediate temp table). The output from orasrp was a lot easier to interpret than the tkprof output. I found some parts of the tkprof misleading (probably my fault).

Posted by Rahul on February 07, 2006 at 09:25 AM PST #

hi, the link returns this messege -> "Due to personal obligations, OraSRP project is closed." is it possible that you share what you have downloaded? kind regards. Tonguç

Posted by tonguc on November 25, 2006 at 11:23 AM PST #

I have uploaded v2.1 of orasrp. This was the last known version with support for Oracle 10g wait events. This is python version so it can be run anywhere there is a python interpreter.

Posted by Glenn Fawcett on December 01, 2006 at 09:36 AM PST #

Post a Comment:
Comments are closed for this entry.