Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Plotting Statspack data

Plotting Statspack data

From: <>
Date: Thu, 4 Mar 2004 16:34:41 +0800
Message-ID: <>

Hi Guys,

I want to hear your comments regarding this present endeavor of mine....

My bosses wants to see some form of automated "database performance indicator reporting" scheme. They want me to create some form of "early warning device" from this kind of scheme, that is, based on certain metrics and some predetermined threshold values, the scheme would notify the admins (including me) if the database needs tuning. I talked to my boss and it was clear to me that he was thinking of ratios (I guess he stopped learning about the Oracle RDBMS after 7.3 ;-)). I explained to him the current paradigm being used by most Oracle DBA's today (I hope) in diagnosing database performance, i.e. wait events analysis. And I told him that the metrics that can tell us systemwide performance is provided by Statspack which is implemented in our site. So, in order to deliver to my bosses this scheme that they wanted, I thought of plotting statspack data using RRDTool. This is different from what Mr. Burleson did in his book, however. What I did is I generated the values that SPREPORT will produce in its output (specifically the "load summary -- per transaction metrics", "instance efficiency percentages", and "top 5 wait events" sections), store it in the database, and plotted it to show daily, weekly, and monthly "trends". The statistics are generated daily for two snapshots (with one hour interval, i know this is quite long) taken during operation peak period. So how I got around the "treshold" values that they demanded? I told them that a baseline will be determined, and metrics that shoots up or down dramatically against this baseline will be investigated.

I just want to know your thoughts on this. I've been so immersed on this project that I may be missing some important points. = )


Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.

Archives are at FAQ is at
Received on Thu Mar 04 2004 - 03:03:35 CST

Original text of this message