You can use this procedure to analyze tables and indexes.
Choose Tools →Administration →Computing Center →Management System →Control →Performance Menu →Database →Tables / Indexes.
Alternatively, use transaction code DB02.
In the Tables and Indexes section there are extensive options available for analyzing tables/indexes. Some of these options are described below:
Limit the number of tables to be analyzed. If, for example, you only enter the name of the tablespace as the selection criterion, the analysis can take a very long time depending on the number of objects contained in the tablespace.
Choose Analysis to examine one of the tables listed in more detail.
See Missing Indexes
Displays critical objects for the storage space situation.
Displays the history of tables/indexes. Limit the number of tables/indexes to be analyzed as best you can. If, for example, you only enter the name of the tablespace as the selection criterion, the analysis can take a very long time depending on the number of objects contained in the tablespace.
The DBA can trace the growth of a table over a particular time period. Changes to size and extent assignment, for example, are recorded. The value for the NEXT storage parameter is also listed. This helps the DBA to monitor the situation in storage-critical tablespaces, that is, to determine whether a next extent of this size will fit into the freespace of a tablespace.
See also:
Checking for Freespace Problems (Oracle)
Storage Management Errors (Oracle)
Checking Storage Parameters (Oracle)
Monitoring Table and Index Fragmentation (Oracle)