RE: making graphical reports from oracle metrics

From: Herring Dave - dherri <>
Date: Tue, 2 Dec 2008 07:55:41 -0600
Message-ID: <>

I'll attest to Tanel's PerfSheet.xls being AWESOME! My only trouble has been with VB, being that I don't know it. Other than that it's worked just fine for me. Can't wait for the non-beta version! :-)


Dave Herring, DBA | A c x i o m M I C S / C S O

630-944-4762 office | 630-430-5988 wireless | 630-944-4989 fax

-----Original Message-----
[] On Behalf Of Tanel Poder Sent: Monday, December 01, 2008 6:10 PM
Subject: RE: making graphical reports from oracle metrics


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:

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 ;)


The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank you.

Received on Tue Dec 02 2008 - 07:55:41 CST

Original text of this message