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.

Start my FREE 18 lesson Machine Learning For Oracle Professionals E-Course here.


Craig Shallahamer is a long time Oracle DBA who specializes in predictive analytics, machine learning and Oracle performance tuning. Craig is a performance researcher and blogger, consultant, author of two books, an enthusiastic conference speaker a passionate teacher and an Oracle ACE Director. More about Craig Shallahamer...


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

CPU Cores Vs Threads: Utilization Difference..Part2B Four Options For Oracle DBA Tuning Training Are You Sure Its The Oracle Database Index Root Block?