RE: What to look for in STATSPACK report

Helmut,

   Performance, like beauty, is in the eye of the beholder. Ideal thresholds only exist in poor tuning courses and poor tuning books. IMHO, the wisest thing to do would be to collect information at a time when performance is perfectly satisfactory and use it as a baseline. Then check when there is some _significant_ difference with your baseline. If nobody complains, it means that you can probably allow pretty wide variations for some values. However, if users do really notice (and it's not purely psycho-somatic, as it sometimes is) some degradation, it will be time to enquire. But bear in mind that the most significant indicators will not necessarily be the same ones for all applications, nor even for all times of day. Also, be careful to collect some information about the actual, business-related work being done. I have seen people complaining that they didn't have the same performance as 6 months earlier and forgetting that they were processing twice as many invoices or whatever. Granted, a well-written application should scale. But at least it helps you explain even the most Oracle-challenged manager that it isn't a simple tuning matter (it will be harder to explain that it isn't a question of throwing more hardware to the problem either, but this is another story).

HTH Stephane Faroult

>----- ------- Original Message ------- -----
>From: "Daiminger, Helmut" <HELMUT.DAIMINGER_at_wwk.de>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Sun, 18 Jan 2004 22:24:36
>
>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: Stephane Faroult
  INET: sfaroult_at_oriolecorp.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).