Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Statspack Intervals

RE: Statspack Intervals

From: Orr, Steve <sorr_at_rightnow.com>
Date: Wed, 10 Jul 2002 06:43:21 -0800
Message-ID: <F001.0049381C.20020710064321@fatcity.com>


We take level 5 snapshots every 15 minutes and keep data for 7 days to a month depending on the table. We rebuild indexes weekly with nologging. I wouldn't bother with backing up this data. It may help to keep the SQL statements in stats$sql_summary to identify bad SQL in monthly report spikes. The amount of data retained depends on your needs, the thresholds you set, and the level of snapshots taken. It took me a little while to automate it for a maintenance free equilibrium.

-----Original Message-----
Sent: Wednesday, July 10, 2002 3:43 AM
To: Multiple recipients of list ORACLE-L

All,  

I've just been rolling out statspack against all of our production DBs. What I am not sure about is how often I should take a snapshot ? I am planning on holding one months worth of data and then backing it up and then purging.  

How often do you guys take snapshots and does my history/purge plan sound reasonable.  

Regards and TIA  

Lee

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Orr, Steve
  INET: sorr_at_rightnow.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). Received on Wed Jul 10 2002 - 09:43:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US