[oracle-l] Re: What to look for in STATSPACK report
- From: Jared.Still@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 22 Jan 2004 13:46:18 -0800
Here's a sample chart. These are generated every morning and available
via our intranet.
http://www.cybcon.com/~jkstill/yapppack_chart.png
Hmmm...
Looks like someone is doing a lot of commits at 02:30 and 05:15.
Jared
Joan Hsieh <joan.hsieh@xxxxxxxxx>
Sent by: ml-errors@xxxxxxxxxxx
01/22/2004 09:19 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L@xxxxxxxxxxx>
cc:
Subject: Re: What to look for in STATSPACK report
Jared,
I played YAPPPACK quite often some time ago. I like it very much. But
somehow I failed to generate the gif file from the csv file as sample
shown. Can someone shade me some light on this? I tied very hard to make
the graphs from the csv file but just don't know how.
Thanks,
Joan
Jared Still wrote:
>
> You will find a utility add on for statspack at Mogens company site,
> www.miracleas.dk. It is called YAPPPACK.
>
> You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate
> response time graphs for your databases.
>
> There are many different numbers to look at in a statspack report, but
> for day to day monitoring, I find them fairly useless. I mean really,
> who's gonna read all that stuff?
>
> Or spend the rest of his life writing a genetic heuristic
> artificially intelligent algorithm that is smart enough to determine
> that something is out of bounds for a particular database?
>
> Use YAPPPACK to track response times. When response times spike
> abnormally, then dig into the statspack data.
>
> JMO,
>
> Jared
>
> On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote:
> > Hi Helmut,
> >
> > There are so many opinions about this that it's hard to point at one
> > specific document or recommendation. If anything, start with stuff
> > written by Graham Wood (who has done a good deal of the work on it),
> > Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about
> > it in his new book, so go look on asktom.oracle.com for his opinions
> > about it.
> >
> > If you hope to find threshold numbers for certain values, etc.... then
> > someone would have automated it a loooong time ago. There can be two
> > reasons for this not having happened: It depends on the installation,
> > situation, etc. - or a lot of system-level measurements are in reality
> > useless. That's pretty much my opinion, but thankfully a lot of much
> > smarter people disagree with me.
> >
> > Best regards,
> >
> > Mogens
> >
> > Daiminger, Helmut wrote:
> >
> > >Hi!
> > >
> > >We want to introduce a performance monitoring policy here. We are
using the
> > >STATSPACK utility.
> > >
> > >What are sections in statspack reports to look for? What are
threshold
> > >numbers for these values?
> > >
> > >Does anybody have any power points or papers about it?
> > >
> > >This is 9.2 on HP-UX.
> > >
> > >Thanks,
> > >Helmut
> > >
> > >
> > >
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
> > INET: mln@xxxxxxxxxxxx
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru@xxxxxxxxxxx (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).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jared Still
> INET: jkstill@xxxxxxxxxx
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru@xxxxxxxxxxx (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joan Hsieh
INET: joan.hsieh@xxxxxxxxx
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@xxxxxxxxxxx (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).
Other related posts:
