I want to free up data from the perfstat tablespace. I got information from somewhere that deleting it this way, all other reaalted data from other stats tables will be deleted as well.
When I try to delete perfstat table space data (1file == 8GB) all in one go, the undo tablespace (1 GB) gives error. That makes sense.
Then, after a week or so, I try to delete from the table little by little, say
delete from stats$snapshot where snap_id < 1000;
it was sucessful
delete from stats$snapshot where snap_id < 2000;
it was sucessful
delete from stats$snapshot where snap_id < 3000;
it was un sucessful, as undo tablespace was filled again.
How can delete the rest of the data from the table and coalscese it to make free space for new stats?
Thanks