RE: Slightly OT: Chart generation tool for db monitoring scripts
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 supporting web server? I'd like to run this off my file system. TIA Raj __ Rajendra JamadagniMIS, 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 2:49 PM To: Multiple recipients of list ORACLE-L scripts out Do a google search for RRD Tool *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 __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Slightly OT: Chart generation tool for db monitoring scripts
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 facts, but having an opinion is an art! -Original Message- Sent: Thursday, August 01, 2002 3:09 PM To: Multiple recipients of list ORACLE-L scripts 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 *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
RE: Slightly OT: Chart generation tool for db monitoring scripts
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: '[EMAIL PROTECTED]' Sorry, I missed the part about automating it. Please let us know how gnuchart works. -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] 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
Re: Slightly OT: Chart generation tool for db monitoring scripts
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: '[EMAIL PROTECTED]' Sorry, I missed the part about automating it. Please let us know how gnuchart works. -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] 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 [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Slightly OT: Chart generation tool for db monitoring scripts
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 __ 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: Tuesday, July 30, 2002 2:51 PM To: Multiple recipients of list ORACLE-L scripts 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. *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
RE: Slightly OT: Chart generation tool for db monitoring scripts
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 from all tables every so often. The trouble I ran into designing my own system was to have a system that is able to do the following. * Allow one system to monitor multiple systems across db links., * Allow easy configuration, especially for things that are different across databases (file names, tablespace names, etc) * All alerting for upper, lower thresholds, also for other thresholds like percentage above or below average. * Tracking averages (I choose to roll my averages into 7 24 hours days, I can quickly see what metrics are currently over average for any particular hour during the day and can average my averages across weekdays, hours etc..When I have a performance problem I usually look at two things, my top sessions (I have posted top.sql previously) and then I see what metrics are over average. * Email/logging integration. * Displaying the data. There were many other problems I came across. But any project tends to grow and grow over time. As far as aggregating your data it is pretty easy to do. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Tuesday, July 30, 2002 3:22 PM To: Multiple recipients of list ORACLE-L scripts 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 __ 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: Tuesday, July 30, 2002 2:51 PM To: Multiple recipients of list ORACLE-L scripts 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Slightly OT: Chart generation tool for db monitoring scripts
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: - read the data dictionary for everything (tablespace names, file names, users, etc). gather appropriate metrics for the things you find in each instance. - implement a servers list (table or file) complete with login information for each instance. have all your monitoring scripts reference that list of servers to be monitored. add a server to the list and viola - you'll soon have metrics for it. we used perl, cron, a Sybase database (we were monitoring Sybase) to make it all work. perl cgi apache to display the data. sendmail and my least favorite, an interface to the pager software for alerts. i thought it was pretty slick. in fact, i was at a party this weekend and witnessed one of my scripts page the on-call DBA. so i know they still use it ;) -Original Message- Sent: Tuesday, July 30, 2002 3:46 PM To: Multiple recipients of list ORACLE-L scripts 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 from all tables every so often. The trouble I ran into designing my own system was to have a system that is able to do the following. * Allow one system to monitor multiple systems across db links., * Allow easy configuration, especially for things that are different across databases (file names, tablespace names, etc) * All alerting for upper, lower thresholds, also for other thresholds like percentage above or below average. * Tracking averages (I choose to roll my averages into 7 24 hours days, I can quickly see what metrics are currently over average for any particular hour during the day and can average my averages across weekdays, hours etc..When I have a performance problem I usually look at two things, my top sessions (I have posted top.sql previously) and then I see what metrics are over average. * Email/logging integration. * Displaying the data. There were many other problems I came across. But any project tends to grow and grow over time. As far as aggregating your data it is pretty easy to do. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Tuesday, July 30, 2002 3:22 PM To: Multiple recipients of list ORACLE-L scripts 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 __ 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: Tuesday, July 30, 2002 2:51 PM To: Multiple recipients of list ORACLE-L scripts 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: STEVE OLLIG INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
RE: Slightly OT: Chart generation tool for db monitoring scripts out
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 generate the output through a SQL query. Actually I'd like to do this for more data, but this is just an example. Thanks 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! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Slightly OT: Chart generation tool for db monitoring scripts out
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. Rajendra.Jamadagn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Slightly OT: Chart generation tool for db monitoring scripts out 07/29/02 11:14 AM Please respond to ORACLE-L 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 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! (See attached file: InterScan_Disclaimer.txt) InterScan_Disclaimer.txt Description: Binary data
RE: Slightly OT: Chart generation tool for db monitoring scripts
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 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 2:49 PM To: Multiple recipients of list ORACLE-L scripts out Do a google search for RRD Tool *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
Re: Slightly OT: Chart generation tool for db monitoring scripts
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, 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 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 2:49 PM To: Multiple recipients of list ORACLE-L scripts out Do a google search for RRD Tool -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 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 Raj __ Rajendra JamadagniMIS, 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! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Slightly OT: Chart generation tool for db monitoring scripts
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 server? I'd like to run this off my file system. TIA 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 2:49 PM To: Multiple recipients of list ORACLE-L scripts out Do a google search for RRD Tool -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Slightly OT: Chart generation tool for db monitoring scripts
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 that lets me go to a page of my choice and see the tabular data which is in html format. I'd like to have some graphs generated to give more visual clues than having to scan the data manually. This is the reason why I am asking. An important one is to measure the 'current block receive time' for our RAC instance. Thanks for any pointers. 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 3:45 PM To: Multiple recipients of list ORACLE-L Hi Raj, What do you want to generate the output in if not html? Beth *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
RE: Slightly OT: Chart generation tool for db monitoring scripts
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 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 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! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kirsch, Walter J (Northrop Grumman) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Slightly OT: Chart generation tool for db monitoring scripts
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 29, 2002 2:14 PM 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 Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
RE: Slightly OT: Chart generation tool for db monitoring scripts
gnuplot on http://sourceforge.net I use it to generate TPM graphs in PNG format, which just happens to be delivered via web, but it obviously doesn't have to. And it even runs on VMS! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] 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 monitoring scripts 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 that lets me go to a page of my choice and see the tabular data which is in html format. I'd like to have some graphs generated to give more visual clues than having to scan the data manually. This is the reason why I am asking. An important one is to measure the 'current block receive time' for our RAC instance. Thanks for any pointers. Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Slightly OT: Chart generation tool for db monitoring scripts
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 __ 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 4:33 PM To: Multiple recipients of list ORACLE-L 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. *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
RE: Slightly OT: Chart generation tool for db monitoring scripts
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 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 that lets me go to a page of my choice and see the tabular data which is in html format. I'd like to have some graphs generated to give more visual clues than having to scan the data manually. This is the reason why I am asking. An important one is to measure the 'current block receive time' for our RAC instance. Thanks for any pointers. 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 3:45 PM To: Multiple recipients of list ORACLE-L Hi Raj, What do you want to generate the output in if not html? Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Slightly OT: Chart generation tool for db monitoring scripts
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 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! *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
RE: Slightly OT: Chart generation tool for db monitoring scripts
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 http://www.geocities.com/epost1/xfim.htm 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 http://www.geocities.com/epost1/xfim_01.gif 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 Raj, I still think MRTG is an option, although I'm sure there are other better ones, like gnuplot that someone else mentioned. Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Slightly OT: Chart generation tool for db monitoring scripts
Even better, use DBD::Chart. It will generate charts directly from the database. Jared Alex [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/29/2002 12:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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-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 generate the output through a SQL query. Actually I'd like to do this for more data, but this is just an example. Thanks 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! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
