Didn't catch the rest of the thread.
If it's not been mentioned, I've used gnuplot using
files that stored data points to create pretty
pictures.
hth
--- Jamadagni, Rajendra
[EMAIL PROTECTED] wrote:
Thanks Ron, Beth,
That is the last option. Do we have anything that
can be used without a
Thanks MKB ... I ended up doing the same thing.
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
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
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
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
__
Actually it isn't that hard.
1. Stuff your data every N minutes into a table with time stamp.
2. Aggregate data every N hours and stuff in other tables (weekly,
monthly, yearly). I wrote some functions that round time to nearest half
hour, two hours etc...to make this easy.
3. Delete old data
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:
Does anyone know of any simple utility that will take a data file and
generate a quick chart. I'd like to generate a chart of number of
transactions per time period. I can generate the output through a SQL query.
Actually I'd like to do this for more data, but this is just an example.
Thanks
MRTG is one.
-Original Message-
Sent: Monday, July 29, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L
out
Does anyone know of any simple utility that will take a data file and
generate a quick chart. I'd like to generate a chart of number of
transactions per time period. I can
:
[EMAIL PROTECTED] Subject: Slightly OT: Chart generation
tool for db monitoring
scripts out
Thanks Ron, Beth,
That is the last option. Do we have anything that can be used without a
supporting web server? I'd like to run this off my file system.
TIA
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN
I just got in on this, but I have used Embaradero's ERstudio. It ran right
of the database and didn't need to connect to the web or anywhere else.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 29, 2002 3:23 PM
Thanks Ron,
perl with GD module
On Mon, 29 Jul 2002, Seefelt, Beth wrote:
MRTG is one.
-Original Message-
Sent: Monday, July 29, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L
out
Does anyone know of any simple utility that will take a data file and
generate a quick chart. I'd
Hi Raj,
What do you want to generate the output in if not html?
Beth
-Original Message-
Sent: Monday, July 29, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L
scripts
Thanks Ron, Beth,
That is the last option. Do we have anything that can be used without a
supporting web
Beth,
Okay ... here is the whole story (I should have done this in my first mail,
but I didn't have time then) ...
1. I currently generate a bunch of HTML reports using SQLPLUS. all these are
stored on my file system. Updated periodically by (gasp) MS task scheduler.
2. I have a navigation page
Give us a sample SQL output and report on that output.
-Original Message-
Sent: Monday, July 29, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L
scripts out
MRTG is one.
-Original Message-
Sent: Monday, July 29, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L
out
Title: RE: Slightly OT: Chart generation tool for db monitoring scripts
Couldn't you do this with, for example, Microsoft Excel? I mention Excel because it's very common, but any spreadsheet program like Lotus 123 could probably do it also.
-Original Message-
Sent: Monday, July
/Tech International, Sussex, WI USA
-Original Message-
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 3:08 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Slightly OT: Chart generation tool for db monitoring
scripts
Beth,
Okay ... here
Thanks,
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.
As I said, I am trying to find an easy way out of this.
Raj
Raj,
I still think MRTG is an option, although I'm sure there are other
better ones, like gnuplot that someone else mentioned.
Beth
-Original Message-
Sent: Monday, July 29, 2002 4:08 PM
To: Multiple recipients of list ORACLE-L
scripts
Beth,
Okay ... here is the whole story (I
Thanks Jesse,
Actually I downloaded gnuplot and am testing it. Looks like it is my ticket.
If anyone is interested, I'll let you know how it goes. I am just trying to
figure out, how to automate it ...
Thanks everyone ...
Raj
__
Rajendra
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
:RE: Slightly OT: Chart generation tool for db monitoring
scripts
perl with GD module
On Mon, 29 Jul 2002, Seefelt, Beth wrote:
MRTG is one.
-Original Message-
Sent: Monday, July 29, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L
out
Does anyone know of any simple
23 matches
Mail list logo