Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Statistics graphing and analysis

Re: Statistics graphing and analysis

From: Rich Jesse <>
Date: Wed, 24 Oct 2007 22:16:46 -0500 (CDT)
Message-ID: <3118.>

Hi Dave,

I use Toad v9 for this. It has a built-in report writer, somewhat similar with what you see with MS Access. For me, I don't bother with textual tabular reports and use it solely for graphing.

Once the reports are created, Toad can be scheduled to run non-interactively to generate the report output whenever you need (e.g. every hour, middle of the night, etc.). While I don't schedule mine, I have one report I run weekly to spit out a bar graph of the 20 largest tables in our ERP DB. Hanging it on my cube wall, folks can get a little better idea of why I'm anxious about the rate with which our largest table is growing. :) And I don't need to use silly cut-and-pasting like one would with Excel -- Toad recognizes my query and automatically loads my custom creation when I ask it for a report on the data.

For more information, check out:

And you can also visit the Yahoo Group and post questions at:

Don't know if this is the answer you're looking for, but probably one you won't get from anyone else on the list (other than Norm!). HTH! GL!


> I'm hoping that I can get a few of you to give feedback / input on tools or
> perhaps even methods for graphing statistics. Currently I've got a variety
> of OS tools gathering OS stats on 15 or so Linux RHEL 4.x and HP Tru64 5.x
> servers, which are then uploaded into Oracle tables. Then on a regular
> basis I run queries to present that data in .csv format, which I then
> cut-paste into Excel and provide a variety of graphs on CPU, memory, space,
> and I/O usage, for current month, past 6 months, and 18 month trend for each
> production server. This is becoming way to much work and I'm trying to find
> a better method.

Received on Wed Oct 24 2007 - 22:16:46 CDT

Original text of this message