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: Ray Stell <>
Date: Tue, 30 Jul 2002 10:50:55 -0800
Message-ID: <>

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.

On Tue, Jul 30, 2002 at 09:44:49AM -0800, Jamadagni, Rajendra wrote:
> Thanks everyone for your kind help, advise and hints.
> I finally got it working with gnuplot.
> I had to make some changes to my code, but this is how it works.
> 1. Every 10 minutes MS task scheduler wakes up and executes a CMD file.
> 2. This CMD file
> a. Executes a SQL script that generates a HTML table output on different
> data.
> b. Generates an appropriate DATA files for the same.
> c. Generates a script for gnuplot to load and generate the plots as gif
> files.
> d. Loads gnuplot and generates the gif files.
> e. Moved the images to their default directories.
> 3. By clocking on the column header (in the HTML report), I open a new
> window and display the plot for that parameter.
> Works very nice ... I have a long way to go yet (to cover all statistics),
> but this has been a good start and good learning on GNUPLOT.
> 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: Monday, July 29, 2002 10:10 PM
> To: ''
> Sorry, I missed the part about automating it. Please let us know how
> gnuchart works.
> > -----Original Message-----
> > From: Jamadagni, Rajendra []
> >
> > me being lazy (and excel ignorant), wanted to find an
> > automated way out of
> > this. If I am going to be generating 10-15 graphs, doing it
> > every half hour
> > might just be too much for me.

> *********************************************************************2
> This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.
> *********************************************************************2

Ray Stell     (540) 231-4109     KE4TJC    28^D
Please see the official ORACLE-L FAQ:
Author: Ray Stell

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 Tue Jul 30 2002 - 13:50:55 CDT

Original text of this message