| 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
I use to put out a PL/SQL package the creates the MRTG configuration file
and also allows you to define all the things you want to track in a table.
It also uses UTL_FILE to hand the info off to MRTG. I still have it lying
around someplace. I have since written my own PL/SQL package and schema
that does this all for me. The nice thing about MRTG is that it takes your
metrics and rolls them up into weekly, monthly and yearly charts. I
incorporated this feature in my own package so it doesn't take a lot of
space. I am sorry I can't share my current tool but I might be able to post
the old tool and you can peruse the somewhat buggy cold. It worked but I
found it too weighty to manage and this can all be done inside the database.
See the following link for yet another old rendition
http://www.geocities.com/epost1/xfim.htm of this type of tool.
I use MS Access to print and display my charts but you could use whatever you wanted since all the data is stored in Oracle. I can also stuff OS performance values in it as well as application specifics (i.e. sales orders per day etc..).
There is a slight chance I can find an old access program I wrote which also does all this but it is client based. It was actually very cool, will make me sad if I can't find a copy. It had an interface very much like this one http://www.geocities.com/epost1/xfim_01.gif
Anyway, if someone is actually serious about trying to build something I will be happy to offer advice. One reason I gave up working on the tool is no one really seemed to care to much about it :( poor me.
:)
Ethan Post
perotdba (AIM), epost1 (Yahoo)
-----Original Message-----
Sent: Monday, July 29, 2002 4:44 PM
To: Multiple recipients of list ORACLE-L
scripts
Raj,
I still think MRTG is an option, although I'm sure there are other better ones, like gnuplot that someone else mentioned.
Beth
--
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 Mon Jul 29 2002 - 17:18:41 CDT
 |
 |
