Oracle-L: RE: Slightly OT: Chart generation tool for db monitoring scripts

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Tue, 30 Jul 2002 12:45:46 -0800
Message-ID: <F001.004A6821.20020730124546@fatcity.com>

Actually it isn't that hard.

Stuff your data every "N" minutes into a table with time stamp.
Aggregate data every "N" hours and stuff in other tables (weekly, monthly, yearly). I wrote some functions that round time to nearest half hour, two hours etc...to make this easy.
Delete old data from all tables every so often.

The trouble I ran into designing my own system was to have a system that is able to do the following.

Allow one system to monitor multiple systems across db links.,
Allow easy configuration, especially for things that are different across databases (file names, tablespace names, etc)
All alerting for upper, lower thresholds, also for other thresholds like percentage above or below average.
Tracking averages (I choose to roll my averages into 7 24 hours days, I can quickly see what metrics are currently over average for any particular hour during the day and can average my averages across weekdays, hours etc..When I have a performance problem I usually look at two things, my top sessions (I have posted top.sql previously) and then I see what metrics are over average.
Email/logging integration.
Displaying the data.

There were many other problems I came across. But any project tends to grow and grow over time.

As far as aggregating your data it is pretty easy to do.

Ethan Post
perotdba (AIM), epost1 (Yahoo)

-----Original Message-----
Sent: Tuesday, July 30, 2002 3:22 PM
To: Multiple recipients of list ORACLE-L scripts

If I can write good SQL to roll up data ... and still generate the charts ... is that a bad thing?

I get your point, but right now, I can't get MRTG working without a web server, and I was looking for a pure file system based solution.

Raj

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
Sent: Tuesday, July 30, 2002 2:51 PM
To: Multiple recipients of list ORACLE-L scripts

Think about how you will roll the trend data up over time. That is usually the real killer task. That is why you got people talking mrtg, because it is the poor man's solution to that problem. At least it is one wheel that has already been invented at the right price.

The snapshots you are making are really not that valuable, but they are better then a stick in the eye.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  INET: Ethan.Post_at_ps.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jul 30 2002 - 15:45:46 CDT