RE: making graphical reports from oracle metrics
- From: "Bort, Guillermo" <guillermo.bort@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 2 Dec 2008 05:03:57 -0600
Well, I would love to try it, and I'm actually downloading it for our testing
environment, however IT Security Dept and Middle Management rejected my
proposal to implement rrdtool even for testing and development dbs. Apparently
Open Source does not go well with the company. We do have some pretty excel
spreadsheets which unfortunately I'm not allowed to share that generate pretty
graphs. I'll be looking into Tanel's spreadsheet since it seems rather advanced.
Still, I don't want to start a flame war here, but I think most 'large'
companies choose not to use open source software for their 'productive'
environments. (still, I have custom PL/SQL executing on all databases in order
to keep them checked, since the 'official' monitoring tool rarely works well
and is usually missconfigured)
Anyway, I've developed a shell script that generates data sources and custom
scripts for each database taking into account defined thresholds for reach
monitored statistic and it works rather well. I'm working on generating metrics
based on those statistics, but that is taking a bit more effort since I first
have to tune the stats gathering sql. Also, the user interface is an APEX based
application with svg graphs, it works flawlessly with both IE and Firefox
(haven't tried it on other browsers).
hth
Guillermo Alan Bort
DBA / DBA Main Team
EDS, an HP company
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Prem Khanna J
Sent: Tuesday, December 02, 2008 8:32 AM
To: tanel@xxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: making graphical reports from oracle metrics
Guys ,
Thanks a ton for all your valuable replies . I was surprised to see no one
using rrdtool .
I thought it is widely used by oracle community . Would like to know if anyone
is using RRDTOOL ?!!!
Hi Tanel , Many thanks for that excel . Let me try that too .
- prem -
Explore your hobbies and interests. Go to
http://in.promos.yahoo.com/groups/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
