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: Jamadagni, Rajendra <>
Date: Tue, 30 Jul 2002 09:44:49 -0800
Message-ID: <>

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
  3. Executes a SQL script that generates a HTML table output on different data.
  4. Generates an appropriate DATA files for the same.
  5. Generates a script for gnuplot to load and generate the plots as gif files.
  6. Loads gnuplot and generates the gif files.
  7. Moved the images to their default directories.
  8. 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.


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.

Please see the official ORACLE-L FAQ:
Author: Jamadagni, Rajendra

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 - 12:44:49 CDT

Original text of this message