Oracle-L: 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