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, > ([EMAIL PROTECTED]) > DBA, Operations Group > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Earle (DBA) INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).