| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Statistics graphing and analysis
You know, this is what's so cool about this list. I've received some
great ideas so far (didn't know about TOAD 9 options - only complain
about developers using TOAD to page through data, then leave their
session opened all day).
A lot of the work I do involves adjusting Excel TREND functions, but after these emails I realized that I could potentially use Oracle's REGR* functions, of course now I have to figure out how. :-)
Thanks everyone!
Dave
David C. Herring, DBA | A c x i o m Delivery Center Organization
630-944-4762 office | 630-430-5988 wireless | 630-944-4989 fax
> -----Original Message-----
> From: Rich Jesse [mailto:rjoralist_at_society.servebeer.com]
> Sent: Wednesday, October 24, 2007 10:17 PM
> To: Herring Dave - dherri
> Cc: oracle-l
> Subject: Re: Statistics graphing and analysis
>
> 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:
>
> http://asktoad.com/DWiki/doku.php/faq/answers/fastreports
>
> And you can also visit the Yahoo Group and post questions at:
>
> http://tech.groups.yahoo.com/group/toad/
>
> 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!
>
> Rich
>
> > 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.
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 Thu Oct 25 2007 - 07:07:26 CDT
 |
 |