Thanks Rajesh.
Looks to be a very interesting tool.
mkb
- Rajesh.Rao_at_jpmchase.com wrote:
>
> Check out the "statspack viewer" tool at
> http://www.geocities.com/alexdabr/
>
>
>
>
>
>
>
>
>
>
> mkb
>
>
> <mkb125_at_yahoo To:
> Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> .com> cc:
>
>
> Sent by: Subject:
> RE: WAITS
>
> root_at_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" <sorr_at_rightnow.com> 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
> > ian_at_slac.stanford.edu
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Orr, Steve
> > INET: sorr_at_rightnow.com
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: Rajesh.Rao_at_jpmchase.com
>
> 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: ListGuru_at_fatcity.com (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).
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mkb
INET: mkb125_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Mon May 13 2002 - 16:23:24 CDT