Oracle9i Database

Solution Preview

One of your dictionary-managed tablespaces seems to run out of space long before you calculated that it would.
There has been a lot of activity in which tables were created, then dropped, and re-created with different storage settings.
Explain why your tablespace has a problem, and list two actions you can take to alleviate the problem.

Solution:
1)Launching Reorg Wizard to Correct Space Problems:

You may decide that you want to correct the space usage problems within the tablespace. To correct these problems, select Reorg Wizard from the Tools menu or the Reorg Wizard toolbar button. The Reorg Wizard allows you to reorganize the space used by problematic schema objects or the entire tablespace. You can also use the Reorg Wizard to repair migrated rows.

There are two options for launching the Reorg Wizard from Tablespace Map:

Tools=>Reorganize Tablespace

Launches the Reorg Wizard to reorganize the entire tablespace

Tools=>Reorganize Selected Segments

Launches the Reorg Wizard in context to the segments that have been identified with blue check marks in the Reorg? column of the Segment List.
By default, segments identified by the Tablespace Analysis as having space usage problems are selected for reorganization

2)Tablespace Map :
Eliminate Tablespace Inefficiencies
Managing the space usage of your tablespaces means using space more efficiently and reducing disk I/Os for improved database responsiveness. The Oracle Tuning Pack can be used to monitor and manage tablespace usage. The Tablespace Map provides "at-a-glance" viewing of tablespace details and space usage. The size and location of objects is presented in a graphical map view, which helps users easily identify the location of segments and extents. Users can select a specific segment and display the location of that segment�s extents, highlighting segment fragmentation. Users can take advantage of the Maps "zoom" feature to explore the details of large tablespaces.

The Tablespace Map also ...