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

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.
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 01: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 03: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 01:36 AM PST #

Post a Comment:
Comments are closed for this entry.
About

This blog discusses performance topics as running on Sun servers. The main focus is in database performance and architecture but other topics can and will creep in.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today
News

No bookmarks in folder

Blogroll

No bookmarks in folder