|
|
|
|
 |
|
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!
|
|
 |
 |
 |
 |
|
|
|
|
 |
|
OraPub M Solver (on-line)
|
Our Price: Free
|
|
|

This on-line web application will solve for M, the number of servers. That is, the number of effective CPU cores or IO devices. There is also a cool link to WolframAlpha.com that will create the response time graph! How to use this application is hinted at in this technical paper and presentation and actually used in Craig's courses Advanced Oracle Performance Analysis and the One-Day Performance Seminars.
DO NOT add this product to your cart and check out. Simply click here to begin using the application. The application is not available for download as I'm sure the algorithm I use is quite laughable.
|
|
 |
 |
 |
 |
|
|
|
|
 |
|
Exploring RT (Mathematica Notepad) (v1d 17-June-2010)
|
Our Price: 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.
|
|
 |
 |
 |
 |
|
|
|
|
 |
|
Exploring Buffer Cache (Mathematica Notepad) (v2d 12-July-2010)
|
Our Price: 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.
|
|
 |
 |
 |
 |
|
|
|
|
 |
|
Firefighting Diagnostic Template (1h, 17-June-2010)
|
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. Do NOT add this item to your cart. Simply click on this link to download the tool.
|
|
 |
 |
 |
 |
|
|
|
|
 |
|
Response Time Graph Template (CPU(1,2) & IO) (1b, 8-Jun-2010)
|
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.
|
|
 |
 |
 |
 |
|
|
|
|
 |
|
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).
|
|
 |
 |
 |
 |
|
|
|
|
 |
|
RT Comparison/Case Graphs (1g, 16-May-2010)
|
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 or effective IO devices.
|
|
 |
 |
 |
 |
|
|
|
|
 |
|
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.
|
|
 |
 |
 |
 |