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 fa
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 wit
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:
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 d
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
__
R
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 ma
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 HT
;
cc:
Subject: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-
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
t
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 Jamada
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 shou
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
_
Quad/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 moni
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-
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
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
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 serv
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 char
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,
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
Do a google search for RRD Tool
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
"The problem with some people is that when they aren't drunk, they're sober."
--William Butler
Yeats.
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 g
22 matches
Mail list logo