The way reorganization jobs are generated has also changed for Reinking. When we experienced space-related problems with our Oracle Applications system, I wanted something quick and easy to use. I used to spend days trying to evaluate the various objects that were causing problems within our Oracle databases. With Space Manager, the same evaluation takes only five or ten minutes. The Bottom Line Before Space Manager, Anoka County ran into errors when they performed reorganizations or rebuilds.
Every script rebuild written contained syntax errors.
Space Manager has caused those problems to vanish and gives Anoka County the ability to generate scripts and set parameters quickly and efficiently. Reinking has found that Space Manager's reporting features help him eliminate future space-related crises. The exception reports and capacity planning graphs help me evaluate the problematic indexes and tables. I can even compare what happened this week versus last week or the week before. That gives me the ability to stabilize those objects before they get out of hand.