RE: making graphical reports from oracle metrics

Hi,

In the end of last year when solving a performance issue I got enough of manual copy & paste from sqlplus to Excel for graphing, so I automated it. The idea is to have a low-effort flexible SQL resultset visualization engine for manual data analysis. Excel combined with SQL data fetching code is pretty good at it. Note that this is not meant to be a standard static monitoring grapher such RRD related stuff but rather a manual ad-hoc data visualization tool.

Here's PerfSheet 2.0 beta:

http://www.tanelpoder.com/files/PerfSheet.zip

It's an Excel file + a little VBA code which:

1. accesses Oracle (or any other) data sources via ADODB
2. runs whatever query you have specified in Queries page
3. loads the data to an excel sheet
4. displays the data in a flexible PivotChart in whatever way you've defined in Views sheet

I've demoed it at Hotsos, OOW and few other places, however I haven't blogged about it yet as I don't have good enough documentation for it yet and there are some limitations I want to resolve some day.

The *problem* is that it already serves its purpose for me and except few glitches it works well enough so I haven't had a need to improve it ;)

Tanel.

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Jesse
> Sent: 01 December 2008 22:29
> To: oracle-l_at_freelists.org
> Subject: Re: making graphical reports from oracle metrics
>
> I have a simple query that reports user tables sorted descending by
> size. I had been dumping this into MS Exxhell every Monday, then
> going through the gyrations of creating the graph to print out and
> hang on my wall for passers by (especially management) to see. The
> problems with this approach are that it's time-consuming and the MS
> Exxhell graph generation is difficult for me to create consistently
> (fonts, size, layout, etc). This made for a less-than-professional
> look as I showed folks the graph history.

--
http://www.freelists.org/webpage/oracle-l