Re: What to look for in STATSPACK report

Helmut,

Register with "http://www.oraperf.com" and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense.

All of the ratio stuff on the STATSPACK report is ignored by the YAPP analyzer, and instead the reformatting looks at things from the standpoint of response-time analysis, as described in the white papers at "http://www.oraperf.com/whitepapers.html".

Yes, I know OraPerf is now owned by Veritas and the real URLs are different, but it'll always be just good old "oraperf.com" hopefully, no matter who Anjo works for... :-)

Hope this helps...

-Tim

on 1/18/04 11:24 PM, Daiminger, Helmut at HELMUT.DAIMINGER_at_wwk.de 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: Tim Gorman
  INET: tim_at_sagelogix.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).