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: Rene <rvangeijn_at_tiscali.nl>
Date: 6 Jan 2006 01:22:50 -0800
Message-ID: <1136539370.468041.193490@f14g2000cwb.googlegroups.com>


$ORACLE_HOME/rdbms/admin/sppurge.sql

dominica_at_gmail.com wrote:
> Hi All,
>
> I am running oracle 8.1.7.4 (32 bit) on 64 bit solaris 2.9 platform.
>
> I am running statpack every 15 minutes.( to collect information like
> execute statspack.snap)
>
> I have a question, what is the best way to maintain the size of the
> tablespace used
> by STATPACK?
>
> I notice now it is using like 27G now.
>
> I want to delete a bunch of data and resize the tablespace back.
> But in my past experience with this same database, I notice, even if I
> delete like 1 months's data, look like the new data is not going in the
> "delete space" and my tablespace's size keep growing..
>
> Any good idea??
>
> Thanks,
>
>
> Dominica
Received on Fri Jan 06 2006 - 03:22:50 CST

Original text of this message

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