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

RE: Slightly OT: Chart generation tool for db monitoring scripts

From: Post, Ethan <>
Date: Mon, 29 Jul 2002 14:18:41 -0800
Message-ID: <>

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 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

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


I still think MRTG is an option, although I'm sure there are other better ones, like gnuplot that someone else mentioned.



Please see the official ORACLE-L FAQ:

Author: Post, Ethan

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: (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

Original text of this message