RE: making graphical reports from oracle metrics
Date: Tue, 2 Dec 2008 07:55:41 -0600
Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E36058A61D0@CWYMSX04.Corp.Acxiom.net>
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
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-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tanel Poder
Sent: Monday, December 01, 2008 6:10 PM
To: oracle-l_at_freelists.org
Subject: 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:
- accesses Oracle (or any other) data sources via ADODB
- runs whatever query you have specified in Queries page
- loads the data to an excel sheet
- 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.
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 02 2008 - 07:55:41 CST