irebuild
irebuild - Oracle Index Rebuild utility
irebuild --sid <SID> --uid <UID> --pwd <PWD> --maxtm <MAXTM> [--debug]
irebuild is a PERL script that will allow the DBA to
rebuild the non-SYS and non-SYSTEM schema indexes
in an Oracle instance. It generates and executes the
ALTER INDEX REBUILD commands in UNRECOVERABLE mode
(since that speeds up index rebuilding). If a problem
is encountered during the index rebuilding operation,
the script logs the Oracle error message to STDERR.
and continues.
You should probably run irebuild from a crontab entry
at a particular time each day/week. You should also
configure the maximum time allowed for the script to
execute so that it is not rebuilding indexes during
times when the database is available to users.
When run with the debug option, irebuild will NOT
rebuild the indexes, it will just generate the SQL
that would be executed to STDERR.
Brad Christensen, bradc@andrews.edu
Copyright (c) 2000, Brad Christensen.
All rights reserved.
The latest release of irebuild can be found at
http://www.andrews.edu/~bradc/irebuild/