Checking for Freespace Problems (Oracle)

You can analyze the storage space situation using the Database Alert Monitor or the Database Monitor (Tablespace Analysis (Oracle)) or Showing Tablespaces with BR*Tools.

An example of freespace analysis with the Database Alert Monitor is shown below. Call this monitor and display freespace problems using the Freespace management display screen.

green	Indicates that no tablespace is in danger of running out of space at the time of the last database check This means that at least one additional extent can be assigned.
yellow or red	Indicates that one or more tablespaces have freespace problems.

Displaying Tablespaces by Available Freespace

To display the 20 tablespaces with the most urgent freespace problems, click the Freespace management field.

A graphic is displayed. The graphic shows the size of every tablespace, available freespace and the average growth of the tablespace per day. Tablespaces with space problems are shown in yellow or red. These tablespaces probably need additional freespace.

To display a forecast for available freespace, click a tablespace in the overview of the freespace problems. A graphic is displayed, which shows when, according to current trends, the freespace will be exhausted. If the entry Extent allocation appears in the Alert field, it means that there are objects in this tablespace which run the risk of an extent overflow. You can display the critical objects by clicking on this field.