Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How release space on tablespace PERFSTAT

605113Oct 25 2007 — edited Nov 8 2007

Hi,
I've problem with low space on tablespace PERFSTAT. I used @?/rdbms/admin/sppurge script to remove most of snaps.
Space on PERFSTAT wasn't release.
Some one know, how can i relese space on this tablespace?

I checked free space below query:
select sum(Bytes) from dba_free_space where tablespace_name = 'PERFSTAT'

This query showed the same values before and after remove snaps.

Thanks for all request.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2007

Added on Oct 25 2007

#general-database-discussions

9 comments

10,758 views