DBA_TABLESPACES

Description of all 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" or "UNDO"
   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
   PLUGGED_IN
      --
   SEGMENT_SPACE_MANAGEMENT
      Segment space management tracking: "AUTO" or "MANUAL"

Related:

DBA_TABLESPACE_GROUPS
DBA_TS_QUOTAS
DBA_TEMP_FILES
DBA_TEMP_FREE_SPACE
DBA_DATA_FILES
DBA_FREE_SPACE_COALESCED


© Copyright SS64.com 1999-2014
Some rights reserved