Skip to Main Content

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 to Reclaim free space after deleting old statistics

samiJul 8 2014 — edited Jul 10 2014

Hi All,

In our database all our most of tablespaces has been filled up only having few GB free..

I have allocated most of my  hard disk space to tablespaces that also has going to be filled.

Now I am running out disk space. I have ordered new disk,  For time being I have to manage the diskspace and tablespace.

So I plan to delete some old statistics by using following command..

exec DBMS_STATS.PURGE_STATS(SYSDATE-15);

But my doubt is whether above will release the free space?

Kindly guide me..

Thanks & Regards

Sami

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2014
Added on Jul 8 2014
16 comments
1,690 views