I use the report that recommends tables for reorganization, and then I automatically generate scripts that reorganize what it reports on. Space Manager's capacity planning capabilities help the DBA to proactively manage the database on a daily basis. We do growth analyses on our tablespaces to avoid the risk of running out of space. As the DBA points out, Space Manager has not only helped improve PeopleSoft application performance, but has also saved him lots or time. I just can't say enough about the Space Manager.
People spend so much time developing scripts to manually look at things.
They could save so much time and effort with Space Manager, doing analysis of all objects and reorganizing the trouble spots. They could be proactive about managing the database and improving application performance. We use Space Manager every day. Inc. All rights reserved.