You are here: > Tools and Products
We found 37 results matching your criteria.
OraPub Tools & Products

Liberally use the search box.

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

We hope you enjoy all that OraPub has to offer!

Here is a direct link to the free OSM Toolkit.

Our premier tool is Stori. Stori is an interactive and automated Oracle Database performance analysis tool. It helps you find, understand and solve Oracle performance problems. The below Stori products allow you get a license, but the main Stori website is HERE.


More Class Pics »
Get student testimonials! »
Sort By:
Page of 1
Stori: Full License
Our Price: $499.95

Automated. Interactive. Oracle Performance Analysis.
StoriFree

Automated. Interactive. Oracle Performance Analysis.
Fulltime.sh - Report both Wait and CPU time detatils (3e, 1-Nov-2013)

The OraPub Fulltime.sh script reports detailed Oracle process wait and CPU information.
Visual Total Time and Response Time Tool (v1b 13-Oct-2012)
Free

Use this tool to visually explore the relationship between total time (think: big bar) and response time (think: time to process a logical IO).
OraPub Quick UOWTBA Web Application (on-line)
Free
TO USE CLICK HERE.

This on-line web application will create a response time curve, calculate the associated math based on a Unit Of Work Time Based Analysis (UOWTBA); all based on data available from an Oracle AWR or Statspack report.
Wait Event Time Distribution Analysis Tool (v4c 13-Nov-2012)
Free

This remarkable tool allows you visually see wait event time distributions and related statistics based on a standard AWR or Statspack report.
SQL Elapsed Time Sampler (e3, 3-May-2012)

OraPub SQL Elapsed Time Sampler: Gather real production elapsed times for a given SQL_ID.
OraPub System Monitor (OSM) Toolkit (v13e for Ora 7-12c,15-Sep-2013)
Free

The OSM tool kit is an Oracle performance management tool kit created by and used by OraPub, Inc.
OraPub M Solver (on-line)
Free
To use click here.

This on-line web application will solve for M, the number of servers.
Library Cache Visualization Tool (v3c 12-Sep-2011)
Free

This remarkable tool allows you visually and interactively explore Oracle's library cache structures.
RT Compare/Case Graphs (1h, 7-Feb-2011)
Free
To download click here.

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.
Firefighting Diagnostic Template (1k, 16-June-2011)
Free
To download click here.

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.
Statistical Analysis Excel Workbook (1c 26-May-2011)
Free
To download click here.

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.
SQL Elapsed Time Collector (1a 31-Jan-2011)
Free
To download click here.

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.
Hash Block Perl Script (26-Jan-2010)
Free
To download click here.

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.
Response Time Graph Template (CPU(1,2) & IO) (1b, 8-Jun-2010)
Free
To download click here.

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.
Exploring RT (Mathematica Notepad) (v1d 17-June-2010)
Free
To download, click here

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.
M/M/m Queuing Theory Analysis Spreadsheet (3d, May 2010)
Free
To download click here.

Oracle Centric CPU Speed Test (1c, 22-Jan-09) w/Results Posted!
Free
To download click here.

RT Interactive Graphs (1b,01-Sep-2009)
Free
To download, click here

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).
Simple Linear Regression Analysis Template (2n 09-July-07)
Free
To download click here.

Hash Text Perl Script (14-Jul-2009)
Free
To download click here.

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.
OraPub Collector (27-Feb-2009)
Free
To download click here.

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

Advanced CPU Forecasting Excel Workbook (1d, 30-July-2008)
Free
To download click here.

Basic CPU Forecasting Excel Workbook (1c, 17-March-2008)
Free
To download click here.

OraPub Load Generator (1c 05-June-2008)
Free
To download click here.

Basic CPU Forecasting Excel Workbook (1b, 21-October-2007)
Free
To download click here.

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

Excel Add-in: M/M/m Queuing Theory Functions (1a, Nov 2007)
Free
To download click here.

Multiple Linear Regression Analysis Template (2g 12-April-07)
Free
To download click here.

Scalability Models Spreadsheet (1a, 13-April-07)
Free
To download click here.

Erlang-C Mathematics in Perl (1a,Jan 2007)
Free
To download click here.

WebLoad - Load Generator (1h 19-April-05)
Free
To download click here.

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

Statistical Significance Analysis Excel Workbook (2a 27-Feb-03))
Free
To download click here.

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.
   
 


view my cart my account my support contact us about us        

Built with Volusion                                To receive OraPub activity updates »