H
hjboxem
Guest
It depends. If the data was removed from an Area other than the Area which contains the tables that are growing fast you would be facing a challenge. When using Storage Area type II with large(r) cluster sizes, those freed blocks couldn't be allocated by other tables because each table uses it's own clusters. And if that isn't fully cleaned it remains allocated for that table. Unless the tables that are cleaned up are the same ones that are growing (fast). Did you run a database analysis before and after the cleaning? You should run these on a regular (weekly) basis to give you an idea on what's happening with your data. Otherwise you are looking at a "black database".
Continue reading...
Continue reading...