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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to delete STATSPACK data efficient to release back space?

Re: How to delete STATSPACK data efficient to release back space?

From: Thiru <WantedToBeDBA_at_gmail.com>
Date: 6 Jan 2006 01:20:45 -0800
Message-ID: <1136539245.544245.254220@g49g2000cwa.googlegroups.com>


Are you really running into any performance problem? If not, then you can reduce the statspack snapshot interval from 15 min to reasonably higher intervel like say 1 ro 2 hours.

Check this link..
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1336002638218

Cheers,
WantedToBeDBA. Received on Fri Jan 06 2006 - 03:20:45 CST

Original text of this message

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