TABLESPACE INFORMATION NOTES:
Tablespace Name - Name of the tablespace
Initial Extent - Default initial extent size
Next Extent - Default incremental extent size
Min Extents - Default minimum number of extents
Max Extents - Default maximum number of extents
Percent Increase - Default percent increase for extent size
Min Ext Size * - Minimum extent size for the tablespace
Status - Tablespace status: ONLINE, OFFLINE, or INVALID (tablespace has been dropped)
Contents - Type of tablespace. This column will have 'TEMPORARY' (v7.3+) for dedicated temporary tablespaces, and 'PERMANENT' for tablespaces that can store both temporary sort segments and permanent objects.
Logging * - Default logging attribute
Extent Mgmt * - Extent management: DICTIONARY or LOCAL
Allocation Type * - Type of extent allocation in effect for this tablespace
Plugged In * - YES, the tablespace is plugged in; NO, it is not plugged in. If a tablespace is transported to an instance, the tablespace has its PLUGGED_IN value set to YES.
By setting PCTINCREASE > 0, the SMON background process will automatically coalesce neighboring free extents in the tablespace.
As of Oracle7.3, you can create a dedicated temporary tablespace. In this kind of tablespace, a single temporary segment is created; it supports multiple users concurrently. The temporary segment does not get dropped when the users no longer needs it; instead, it remains in the temporary tablespace awaiting another user request for temporary segment space. Keeping the temporary segment in place avoids the costs associated with the creation and dropping of temporary segments.
* - Denotes v8 columns