Integrating Stori Into Your Oracle Database Performance Management System

Posted on 21-Dec-2013 by Craig Shallahamer, craig@orapub.com

Wouldn't it be nice to integrate OraPub's Oracle Database performance product Stori into an existing performance monitoring system? Suppose you want to chart performance. Or suppose you want an alert or a trigger fired if performance is crosses a threshold. This is easy with Stori because performance is quantified and Stori makes this numeric information available.

Let's take a simple example.

How can I help you? Is there a problem?

It is a very slight IO situation.

Stori's English response is actually a transformation from the number 2.009. But where does this 2.009 come from? While the quantitative details are Stori's secret, you ask Stori for the numeric result by asking a lower level get command and then decode the results! Here is an example.

How can I help you? get problem

2.009

The integer part of the number represents the OS area of most concern and the fractional part represents the problem intensity. A 1 references the CPU subsystem, 2 the IO subsystem, 3 the memory subsystem, 4 the network subsystem and 5 means there is no OS bottleneck. The fractional range goes from 0 to .999 with 0 being the lest intensity and .999 meaning there is a massive bottleneck!

If you're like most DBAs, you're probably thinking how easy it would to parse through the output and hook it into another performance monitoring system.

For example, you could create a Playback file that has only these two commands:

set scope latest
get problem

Using cron, each hour run the Playback file, parse the output (some simple awk and grep is all it takes), and send it to your performance monitoring system.

If you are an Oracle performance tool vendor, OraPub can give you direct access to the Stori PLSQL package. This means you can send Stori command and retrieve the result all within PLSQL! This technique can be used for simple numeric output but also any Stori output...including the analyze commands! The possibilities are limitless.

All the best in your Oracle database performance tuning work!

Craig.

If you have any questions or comments, feel free to email me directly at craig at orapub.com.

Tool Options: Detailing Oracle Database Process CPU Consumption Does Increasing An Oracle Database Background Process OS Priority Improve Performance? Is Oracle Database 12c (12.1.0.2.0) Faster Than Previous Releases