Free Space Deficit (ORCL)
Go Up to Data, Schema, and Miscellaneous Utilities
One of the central tasks of every Oracle administrator is to monitor the availability of free space in tablespaces. When a data segment (e.g., table, index or cluster) is created on a tablespace, it acquires an initial extent of a determined size. As it grows, the data segment will eventually need to acquire another extent to store additional data. If a data segment cannot acquire its next extent, all further transactions on it will fail.
The Free Space Deficit Monitor identifies any objects that will not be able to acquire their next extent. Whenever it identifies a problem data segment, you should take corrective action as soon as possible. To address the problem, you can:
- Reduce the object's Next Extent Size from the appropriate Object Editor.
- Increase the availability of free space in the tablespace by:
- Adding datafiles.
- Activating autoextend for the tablespace's datafiles. Autoextend allows the datafiles to grow to fill available room on the physical drive. This option is only available with Oracle.
The table below describes the objects:
| Category | Information | Description |
|---|---|---|
|
Tablespace |
Name |
Name of the tablespace. |
|
Largest Free Section |
Largest contiguous section of free space in a tablespace. | |
|
Objects |
Object Name |
Name of any object that will not be able to acquire its next extent because it will be larger than the Largest Free Section. |
|
Object Type |
Type of the object, such as a table, index or cluster, that will not be able to acquire its next extent. | |
|
Next Extent |
Specified size of the object's next extent. One of the options you have to correct the problem is to reduce the next extent size so that it is smaller than the Largest Free Section. |
Opening the Free Space Deficit Dialog Box
- On the Utilities menu, select Free Space Deficit.
- DBArtisan opens the Free Space Deficit dialog.
The table below describes the options and functionality on the Free Space Deficit dialog:
| Option | Description |
|---|---|
|
Owner |
Lets you click the owner for whom you want to analyze free space. |