You are here: Home > Tools / Products
We found 33 results matching your criteria.

Liberally use the search box (upper left of every page).

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.

We hope you enjoy all that OraPub has to offer!
More Class Pics »
Get student testimonials! »
Sort By:
Page of 1
Exploring Buffer Cache Visualization (v6e 12-Sep-2011)
Free

This Mathematica based tool will allow you visually and interactively explore the key Oracle buffer cache structures; the buffer headers, least recently used lists, cache buffer chains, and the write/dirty lists.
Statistical Significance Analysis Excel Workbook (2a 27-Feb-03))
Free

Stock Trader Load Generator (2h 19-April-05)
Free

WebLoad - Load Generator (1h 19-April-05)
Free

Erlang-C Mathematics in Perl (1a,Jan 2007)
Free

Scalability Models Spreadsheet (1a, 13-April-07)
Free

Multiple Linear Regression Analysis Template (2g 12-April-07)
Free

Excel Add-in: M/M/m Queuing Theory Functions (1a, Nov 2007)
Free

Forecasting data collection script for Oracle and OS (v1.1 May 11, 2007)
Free

Basic CPU Forecasting Excel Workbook (1b, 21-October-2007)
Free

OraPub Load Generator (1c 05-June-2008)
Free

Basic CPU Forecasting Excel Workbook (1c, 17-March-2008)
Free

Advanced CPU Forecasting Excel Workbook (1d, 30-July-2008)
Free

Forecasting data collection script for Oracle and OS (v1.2 03-Sept-2008)
Free

OraPub Collector (27-Feb-2009)
Free

Hash Text Perl Script (14-Jul-2009)
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.
Simple Linear Regression Analysis Template (2n 09-July-07)
Free

RT Interactive Graphs (1b,01-Sep-2009)
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).
Oracle Centric CPU Speed Test (1c, 22-Jan-09) w/Results Posted!
Free

M/M/m Queuing Theory Analysis Spreadsheet (3d, May 2010)
Free

Exploring RT (Mathematica Notepad) (v1d 17-June-2010)
Free

This Mathematica based tool will allow you interactively explore how the core response time parameters change the response time curve or to perhaps plot a response time curve based on real performance data.
Response Time Graph Template (CPU(1,2) & IO) (1b, 8-Jun-2010)
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.
Hash Block Perl Script (26-Jan-2010)
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.
Oracle DB Server Stress Identifier (v2a)
Our Price: $49.95

DB Server Stress Identifier
SQL Elapsed Time Collector (1a 31-Jan-2011)
Free

The purpose of this toolkit is go gather data about a specific SQL statement to analyze the distribution of resource consumption and elapsed execution time.
Statistical Analysis Excel Workbook (1c 26-May-2011)
Free

This Excel based tool allows easy entry of sample data and automatically derives many of the standard statistics, a very useful graph, and other goodies.
Firefighting Diagnostic Template (1k, 16-June-2011)
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.
RT Compare/Case Graphs (1h, 7-Feb-2011)
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 or effective IO devices.
Wait Event Time Distribution Analysis Tool (v4a 11-Oct-2011)
Free

This remarkable tool allows you visually see wait event time distributions and related statistics based on a standard AWR or Statspack report.
Library Cache Visualization Tool (v3c 12-Sep-2011)
Free

This remarkable tool allows you visually and interactively explore Oracle's library cache structures.
OraPub M Solver (on-line)
Free

This on-line web application will solve for M, the number of servers.
OraPub System Monitor (OSM) Toolkit (v13b for Ora 7-11g, 8-Jan-2012)
Free

The OSM tool kit is an Oracle performance management tool kit created by and used by OraPub, Inc.
SQL Elapsed Time Sampler (e3, 3-May-2012)

OraPub SQL Elapsed Time Sampler: Gather real production elapsed times for a given SQL_ID.