Get the purge package written by Tim Gorman available from http://www.evdbt.com/tools.htm (no 31 on the list) Install it as user perfstat and then create the folloiwng 2 dbms_jobs as user perfstat to take snapshots every hour and purge snapshot data older than 7 days
Works on 8.1.7 & 9 (but not on 8.1.6 because the perfstat tables have changed since then) declare l_job number; begin dbms_job.submit (l_job,'statspack.snap;',trunc(sysdate)+13/24,'sysdate+1/24'); --every hour on the hour end; / declare m_job number; begin dbms_job.submit (m_job,'sppurpkg.purge(7);', trunc(sysdate)+12/24,'sysdate+1'); end; / John -----Original Message----- Sent: 04 September 2003 21:05 To: Multiple recipients of list ORACLE-L I too have mine setup to take a snapshot every 15 minutes. Can you teach me how to automate purges using sppurge.sql ? Thanks ......... ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 29, 2003 06:04 > Start by installing and configuring statspack. > > I have mine setup to take a snapshot every 15 minutes. > > It collects a lot of data, I am now in the midst of automating a purge > process. :) > > Then implement YAPPPACK from http://www.miracleas.dk/en/tech.html > and use the data to create response time charts. > > At least, that's one way to do it. > > Jared > > > > > > > Jake Johnson <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 08/28/2003 04:59 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject: How can I measure my DB performance. > > > Is there a standard query I can run to compare the performance of a db. > (Kind of like bogomips for unix) > > Thanks, > Jake Johnson > [EMAIL PROTECTED] > > ______________________________________________________________________ > Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on > Rims, Tires, and Wheel Packages. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jake Johnson > INET: [EMAIL PROTECTED] > > 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: [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). > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] 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: [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).
