15 minutes ! All our production db are set up at 1 hour interval. A summary of the stats are centralized in 1 db and we keep that 2 months. We go down to 10-15 minues to investigate problems.
I find a 15 minutes interval very short. Thanks for the link to yapppack. We do a similar thing using a chart software. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 4:05 PM 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: Stephane Paquette 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).
