Check out the "statspack viewer" tool at http://www.geocities.com/alexdabr/
mkb
<mkb125@yahoo To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
.com> cc:
Sent by: Subject: RE: WAITS
root@fatcity.
com
May 13, 2002
10:03 AM
Please
respond to
ORACLE-L
That's neat. I working on HTML/GUI interface to
statspack. I think I've got most of the thing figured
out. Right now, I'm able to display phys read/write
IO directly from one of the statspack tables every
hour displayed in graphincal format on a web page.
Working on other reports as well.
Would love to be able to pool resources here and
bounce off some ideas.
mkb
--- "Orr, Steve" <[EMAIL PROTECTED]> wrote:
> > Each morning I produce graphs...
> I think this is key. Having historical data
> graphically presented helps to
> establish the norm and when there may be performance
> issues to investigate.
> This follows step 2 of Gaja's "Oracle Performance
> Tuning 101 Methodology"
> which says, "Measure and document current
> performance."
>
> To do this I created a DBA monitoring HTML display
> tool which gets data from
> V$SYSSTAT and V$SYSTEM_EVENT once a minute, stores
> it in a round robin
> database and displays it with RRDTool. I've
> accumulated 2 months of this
> data and it's amazing how lightweight it is. With
> graphs it's easy to see
> when something's amiss. We capture expensive SQL via
> StatsPack every 15
> minutes and I have correlated a spike on a graph to
> specific SQL executed 2
> hours earlier.
>
> Now I'm trying to decide on my next enhancement: 1)
> HTML/GUI interface to
> StatsPack data or; 2) Drill down to V$SESSION_WAIT
> ???
>
>
> Steve Orr
> Bozeman, Montana
>
>
>
> -----Original Message-----
> Sent: Thursday, May 09, 2002 5:23 PM
> To: Multiple recipients of list ORACLE-L
> Importance: High
>
> In general There are two problems in using the "top
> five waits" out of
> statspack: it reports idle waits; no matter how
> well-tuned your database
> there will always be a top five. The numbers
> presented show total
> time-waited in csecs for the time period. As Jared
> said we don't know the
> time period. We don't know the average wait time.
>
> I have learned some rudimentary gnuplot skills.
> Each morning I produce
> graphs of what went on the in the databases the
> previous day on and hour by
> hour basis. If something is really askew I break
> the hour down into ten
> minute blocks. This helps me to better recognize
> patterns of database
> usage.
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Orr, Steve
> INET: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
