DBA_TABLESPACES

DBA_TABLESPACES describes all tablespaces in the database.

Related View

• USER_TABLESPACES describes all tablespaces accessible to the current user. This view does not display the PLUGGED_IN column.

  Column	Datatype	NULL	Description
  TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Tablespace name
  BLOCK_SIZE	NUMBER	NOT NULL	Tablespace block size
  INITIAL_EXTENT	NUMBER		Default initial extent size
  NEXT_EXTENT	NUMBER		Default incremental extent size
  MIN_EXTENTS	NUMBER	NOT NULL	Default minimum number of extents
  MAX_EXTENTS	NUMBER		Default maximum number of extents
  PCT_INCREASE	NUMBER		Default percent increase for extent size
  MIN_EXTLEN	NUMBER		Minimum extent size for the tablespace
  STATUS	VARCHAR2(9)		Tablespace status (ONLINE, OFFLINE, or READ ONLY)
  CONTENTS	VARCHAR2(9)		Tablespace contents (PERMANENT, or TEMPORARY)
  LOGGING	VARCHAR2(9)		Default logging attribute
  EXTENT_MANAGEMENT	VARCHAR2(10)		Extent management tracking (DICTIONARY or LOCAL)
  ALLOCATION_TYPE	VARCHAR2(9)		Type of extent allocation in effect for this tablespace
  PLUGGED_IN	VARCHAR2(3)		YES indicates the tablespace is plugged in; NO indicates the tablespace is not plugged in
  SEGMENT_SPACE_MANAGEMENT	VARCHAR2(9)		(AUTO|MANUAL) Indicates whether or not the segment management in this tablespace is managed using free lists (MANUAL) or bitmaps (AUTO)