Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_TABLESPACES

Description of accessible tablespaces

Columns
   ___________________________
 
   TABLESPACE_NAME
      Tablespace name
   BLOCK_SIZE
      Tablespace block size
   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
   PCT_INCREASE
      Default percent increase for extent size
   MIN_EXTLEN
      Minimum extent size for the tablespace
   STATUS
      "Tablespace status: "ONLINE","OFFLINE",or "READ
   CONTENTS
      Tablespace contents: "PERMANENT",or "TEMPORARY" 
   LOGGING
      Default logging attribute
   FORCE_LOGGING
      Tablespace force logging mode
   EXTENT_MANAGEMENT
      Extent management tracking: "DICTIONARY" or "LOCAL"
   ALLOCATION_TYPE
      Type of extent allocation in effect for this tablespace
   SEGMENT_SPACE_MANAGEMENT
      Segment space management tracking: "AUTO" or "MANUAL"

Related:



Simon Sheppard
SS64.com