RE: making graphical reports from oracle metrics

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Prem Khanna J Sent: Tuesday, December 02, 2008 8:32 AM To: tanel_at_poderc.com; oracle-l_at_freelists.org 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/ --
http://www.freelists.org/webpage/oracle-l

†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Tue Dec 02 2008 - 05:03:57 CST