| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Slightly OT: Chart generation tool for db monitoring scripts
Ethan - I empathize with some of the monitoring issues you had trouble with.
In a former life I was tasked with implementing a custom monitoring system
for a shop with over 150 database servers. In fact - we dedicated a server
to monitoring the others. A couple tips that saved us a lot of time:
we used perl, cron, & a Sybase database (we were monitoring Sybase) to make it all work. perl cgi & apache to display the data. sendmail and my least favorite, an interface to the pager software for alerts.
i thought it was pretty slick. in fact, i was at a party this weekend and witnessed one of my scripts page the on-call DBA. so i know they still use it ;)
-----Original Message-----
Sent: Tuesday, July 30, 2002 3:46 PM
To: Multiple recipients of list ORACLE-L
scripts
Actually it isn't that hard.
The trouble I ran into designing my own system was to have a system that is able to do the following.
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
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: STEVE OLLIG INET: sollig_at_lifetouch.com 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 - 16:40:05 CDT
 |
 |