|
Oracle
Enterprise Manager Reorg
Wizard
Every database administrator's goal is to
reduce planned downtime and increase application availability.
Oracle9i
provides a powerful mechanism to reorganize and redefine tables
and indexes while keeping them online and available to application
users. Table and index reorganization improves application
performance. Administrators can now perform a variety
of online reorganization operations while users have full
access to all objects.
Over time, database performance can be affected
by problems such as row chaining or migration and index stagnation.
Oracle Enterprise Manager Reorg Wizard helps you maintain
a well performing database by correcting space usage problems.
In addition, the Reorg Wizard gives the option to perform
these operations online while the objects are fully accessible.
The Reorg Wizard can eliminate space problems
by reorganizing database space usage. It also allows you to
change objects storage settings and location. The Reorg Wizard
gives you three reorganization options:
- Reorganize specific schema objects, such
as tables or indexes
- Reorganize an entire tablespace
- Repair migrated rows
The Reorg Wizard performs reorganizations completely
within the Oracle database using SQL. Reorganizations
can be performed within the target tablespace or by temporarily
using space in another tablespace. The Reorg Wizard allows you
to indicate whether the generated script should favor availability
or speed. If availability is chosen, the generated script
will take full advantage of online capabilities supported by
the server. On the other hand, if speed is chosen, the
generated script will always use an off-line reorganization
approach. The Reorg Wizard evaluates the reorganization
operations and generates an Impact Report and reorganization
script as shown below.
These reports can be reviewed prior to execution
and the administrators can decide on the appropriate next
steps. Reorganizations can be performed immediately or can
be scheduled to be performed at a later time, perhaps
during off-peak hours.
More
Info
Oracle9i
Database Daily Features
|
Bookmark
