RE: Statistics graphing and analysis

  • From: "Vishal Gupta" <vishal@xxxxxxxxxxxxxxxxx>
  • To: "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 25 Oct 2007 16:37:30 +0100

I use ORCA to plot graphs from statspack and AWR statistics and OS
statistics.

http://www.orcaware.com/ 
http://www.hoopoes.com/cs/orca/ 

Example 
http://www.hoopoes.com/cs/orca/oracle_example-daily.shtml 
http://www.orcaware.com/orca/example_sites.html 


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Herring Dave - dherri
Sent: 25 October 2007 13:07
To: rjoralist@xxxxxxxxxxxxxxxxxxxxx
Cc: oracle-l
Subject: 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@xxxxxxxxxxxxxxxxxxxxx]
> 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.
*************************************************************************
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.
*************************************************************************
--
//www.freelists.org/webpage/oracle-l



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


Other related posts: