Tuning Pack
This pack includes these applications:
- Expert
Helps with the initial configuration of an Oracle database and makes recommendations for modifications to the database to improve performance. Expert also generates scripts to implement these recommendations.
- Index Tuning Wizard
Generates suggestions concerning tables that could use additional indexes and the scripts for implementing those recommendations.
- SQL Analyze
Analyzes and compares optimization plans for SQL statements, as well as helps to improve the performance with hints.
- Tablespace Map and Analysis
Displays information about tablespaces and an analysis that can detect potential space management problems.
- Reorg Wizard
Can reorganize specific schema objects or tablespaces or repair migrated rows. This application is new as a standalone application with Oracle9i.
- Outline Management
Helps to manage stored outlines. This application is new as a standalone application with Oracle9i.
- Outline Editor
Allows easy editing of stored outlines. This application is new as a standalone application with Oracle9i.
- Auto Analyze
Automatically maintains the statistics for an Oracle8i database. This application was not offered as of Oracle9i.