DBA_TABLESPACES

Description of all tablespaces

Columns
   ___________________________
 
   LOGGING
      Default logging attribute
   MIN_EXTENTS
      Default minimum number of extents
   TABLESPACE_NAME
      Tablespace name
   ALLOCATION_TYPE
      Type of extent allocation in effect for this tablespace
   NEXT_EXTENT
      Default incremental extent size
   PLUGGED_IN
   MAX_EXTENTS
      Default maximum number of extents
   PCT_INCREASE
      Default percent increase for extent size
   MIN_EXTLEN
      Minimum extent size for the tablespace
   STATUS
      Tablespace status: `ONLINE`, `OFFLINE`, or `READ ONLY`
   CONTENTS
      Tablespace contents: `PERMANENT`, or `TEMPORARY`
   EXTENT_MANAGEMENT
      Extent management tracking: `DICTIONARY` or `LOCAL`
   INITIAL_EXTENT
      Default initial extent size

Related Commands:

Simon Sheppard
SS64.com