Re: Space wasted because of automatic undo management

if space is that much of a problem:
 drop and re-create the tempfiles and make the developers fix the statements.
 don't install (uninstall) the unneeded, unused components.  reduce the ts_quotas for users.
 get rid of the redundant indexes.
 remove the unneeded old oracle homes
 remove the .dfj files underneath
$ORACLE_HOME/assistants/dbca/templates
 migrate to 10.1 from 9.2, its less than half the footprint for the db server binaries.
 look for old datafiles that are no longer part of the database but are still in the filesystem.

I'll bet that you reclaim plenty of wasted space.

-bdbafh Received on Fri Apr 01 2005 - 14:26:10 CST