Re: What to look for in STATSPACK report

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_at_miracleas.dk
>
> 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_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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

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_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).