How to delete STATSPACK data efficient to release back space?

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 Thu Jan 05 2006 - 19:16:08 CST