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