Scheduling for Statspack

        Hi,

> I have a question with regard to the best scheduling for Statspack. I am
> running Oracle 8.1.6.2 on Hp UX11. I see that the oraperf site recommends
> no more than intervals of (5 to 15 minutes) to tune performance problems.
> Does setting up a schedule with 96 or 288 snaps at level 5 put a heavy
> load on the system?
> I am still trying to get some performance problems with disk i/o and
> latch contention sorted out, but I also want to keep baseline statistics
> to monitor how well my tuning effort is proceeding. What period would you
> recommend setting dbms jobs to monitor a busy production system?
> How about hourly for the snapshots and then use a 1 or 2 hour block to
> keep for historical data. I plan on purging every 14 days but I want to
> keep something for each day. If I do this how will I be able to tune for
> performance problems?
>
> Any advice will be greatly appreciated
> Sincerely,
>
>
>
> Jay Earle, BSc(CS) OCP,
> (jay_earle_at_smartforce.com)
> DBA, Operations Group
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jay Earle (DBA)
  INET: Jay_Earle_at_smartforce.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).