You are here: Home > Tools / Products
OraPub, Inc. is pleased to offer its tools to any Oracle user, consulting company, training company, and even Oracle employees. Nearly all of our tools are free! The free tools are copyrighted by OraPub, but you may use them as long as they don't change the copyright notice and file header. Email support if you have suggestions or comments.

The free OraPub tools come with absolutely no guarantee. If they crash and destroy your system (which they are not intended to do), it is solely your responsibility. Download, install, and use them at your own risk. OraPub, Inc. assumes absolutely no liability. I think you get my point. OraPub non-free tools/products contain a license agreement with all the usual legal details.

If you are only interested in firefighting tools, then do a search (bottom left) for tools firefighting. If predictive analysis, then search for tools forecasting.

We hope you enjoy all that OraPub has to offer!
More Class Pics »
Get student testimonials! »
Sort By:
Page of 3  
Oracle DB Server Stress Identifier (v2a)
Our Price: $49.95

DB Server Stress Identifier
OraPub System Monitor (OSM) Toolkit (v12y for Ora 7-11g, 08-Feb-2010)
Our Price: Free

You can view the actual scripts one at a time here. The OraPub System Monitor (OSM) is the tool kit referenced in Shallahamer's book, Oracle Performance Firefighting, used during OraPub consulting engagements, technical research, and during our training classes. The OSM is a complete set of performance diagnostic tools based upon response time analysis. It also contains a fantastic historical analysis pack (which will be eventually replaced with Statspack/AWR based reports). The OSM is sqlplus based, non-graphic, and comes with absolutely no warranty....and you'll love it!
Hash Text Perl Script (14-Jul-2009)
Our Price: Free

Given the number of hash buckets and the text to hash, this Perl script will create a hash value, hash the text, and assign it to a hash bucket. This simple perl script helps one understand how Oracle looks for existing objects in the shared pool's library cache. This is the script presented in Shallahamer's book, Oracle Performance Firefighting, in the Shared Pool chapter and also demonstrated in his training course by the same name.
Firefighting Diagnostic Template (1f, 21-Nov-2009)
Our Price: Free

Use this MS-Excel based template to methodically and quantitatively diagnose Oracle system performance issues. The template encourages diagnosis using response time analysis and OraPub's 3-circle analysis methods and prepares for a deep analysis both quantitatively and graphically.

The basis of this template is discussed in Shallahamer's book, Oracle Performance Firefighting, in his Oracle Performance Firefighting training course, and used in a deeper fashion in his Advanced Oracle Performance Analysis course.
Response Time Graph Template (CPU(1,2) & IO) (1a, 17-Jul-2009)
Our Price: Free

Use this MS-Excel based template to create a response time graph based upon real and potentially partial performance data. There are two CPU based RT graphs and one IO based RT graph. You choose which one to use based on the available information.

The basis of this graph and tool are discussed in Shallahamer's book, Oracle Performance Firefighting, in his Oracle Performance Firefighting training course, and used in a deeper fashion in his Advanced Oracle Performance Analysis course.
RT Interactive Graphs (1b,01-Sep-2009)
Our Price: Free

This is very cool! This MS-Excel tool numerically displays and graphs the response time, utilization, and queue length as you click the slider bars. The slider bars control the three input parameters; number of CPU cores, service time, or arrival rate (workload). This is an excellent learning tool and can also be used to demonstrate how your firefighting solutions will generally effect performance.

The basis of this graph and tool are discussed in Shallahamer's book, Oracle Performance Firefighting, in his Oracle Performance Firefighting training course, and used in a deeper fashion in his Advanced Oracle Performance Analysis course.

1b 01-Sep-2009. Added the utilization and queue length graphs in addition to the existing response time graph. Also added the queue length calculation cell.
RT Comparison/Case Graphs (1f, 25-Sep-2009)
Our Price: Free

This MS-Excel tool makes it very easy to both numerically and graphically compare three different performance situations in a response time focused manner. Each of the three cases allows input for the arrival rate (workload), service time, and number of CPU cores. The numerical output for each case is the calculated utilization, queue time, and response time. All three response time curves are color coded and combined into a single graph. Furthermore, the workload situation for each case is highlighted by a large data plot circle. This tool makes it very easy to show the current situation and two possible performance enhancing solutions.

The basis of this graphical tool are discussed in Shallahamer's book, Oracle Performance Firefighting, in his Oracle Performance Firefighting training course, and used in a deeper fashion in his Advanced Oracle Performance Analysis course.
Hash Block Perl Script (26-Jan-2010)
Our Price: Free

Given the number of hash buckets, the file number, and the block number,  this simple perl script will generate the hash value, hash the value, and assign it to a hash bucket. This is a great way to learn about how Oracle uses hashing to check if a block is in the Oracle buffer cache as well as issues related to the cache buffer chain structure, latching, and concurrency issues. This is the script presented in OraPub's course, Oracle Performance Firefighting.
OraPub Collector (27-Feb-2009)
Our Price: Free

Oracle Centric CPU Speed Test (1c, 22-Jan-09) w/Results Posted!
Our Price: Free