DBA_TABLESPACES

DBA_TABLESPACES describes all tablespaces in the database.

Related View

USER_TABLESPACES describes the 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`	Name of the tablespace
`BLOCK_SIZE`	`NUMBER`	`NOT NULL`	Tablespace block size (in bytes)
`INITIAL_EXTENT`	`NUMBER`		Default initial extent size (in bytes)
`NEXT_EXTENT`	`NUMBER`		Default incremental extent size (in bytes)
`MIN_EXTENTS`	`NUMBER`	`NOT NULL`	Default minimum number of extents
`MAX_EXTENTS`	`NUMBER`		Default maximum number of extents
`MAX_SIZE`	`NUMBER`		Default maximum size of segments (in Oracle blocks)
`PCT_INCREASE`	`NUMBER`		Default percent increase for extent size
`MIN_EXTLEN`	`NUMBER`		Minimum extent size for this tablespace (in bytes)
`STATUS`	`VARCHAR2(9)`		Tablespace status: `ONLINE` `OFFLINE` `READ ONLY`
`CONTENTS`	`VARCHAR2(9)`		Tablespace contents: `UNDO` `PERMANENT` `TEMPORARY`
`LOGGING`	`VARCHAR2(9)`		Default logging attribute: `LOGGING` `NOLOGGING`
`FORCE_LOGGING`	`VARCHAR2(3)`		Indicates whether the tablespace is under force logging mode (`YES`) or not (`NO`)
`EXTENT_MANAGEMENT`	`VARCHAR2(10)`		Indicates whether the extents in the tablespace are dictionary managed (`DICTIONARY`) or locally managed (`LOCAL`)
`ALLOCATION_TYPE`	`VARCHAR2(9)`		Type of extent allocation in effect for the tablespace: `SYSTEM` `UNIFORM` `USER`
`PLUGGED_IN`	`VARCHAR2(3)`		Indicates whether the tablespace is plugged in (`YES`) or not (`NO`)
`SEGMENT_SPACE_MANAGEMENT`	`VARCHAR2(6)`		Indicates whether the free and used segment space in the tablespace is managed using free lists (`MANUAL`) or bitmaps (`AUTO`)
`DEF_TAB_COMPRESSION`	`VARCHAR2(8)`		Indicates whether default table compression is enabled (`ENABLED`) or not (`DISABLED`) Note: Enabling default table compression indicates that all tables in the tablespace will be created with table compression enabled unless otherwise specified.
`RETENTION`	`VARCHAR2(11)`		Undo tablespace retention: `GUARANTEE` - Tablespace is an undo tablespace with `RETENTION` specified as `GUARANTEE` A `RETENTION` value of `GUARANTEE` indicates that unexpired undo in all undo segments in the undo tablespace should be retained even if it means that forward going operations that need to generate undo in those segments fail. `NOGUARANTEE` - Tablespace is an undo tablespace with `RETENTION` specified as `NOGUARANTEE` `NOT APPLY` - Tablespace is not an undo tablespace
`BIGFILE`	`VARCHAR2(3)`		Indicates whether the tablespace is a bigfile tablespace (`YES`) or a smallfile tablespace (`NO`)
`PREDICATE_EVALUATION`	`VARCHAR2(7)`		Indicates whether predicates are evaluated by host (`HOST`) or by storage (`STORAGE`)
`ENCRYPTED`	`VARCHAR2(3)`		Indicates whether the tablespace is encrypted (`YES`) or not (`NO`)
`COMPRESS_FOR`	`VARCHAR2(30)`		Default compression for what kind of operations: `BASIC` `ADVANCED` `QUERY LOW` `QUERY HIGH`¹ `ARCHIVE LOW`¹ `ARCHIVE HIGH`¹ `NULL`
`DEF_INMEMORY`	`VARCHAR2(8)`		Indicates whether the In-Memory Column Store (IM column store) is by default enabled (`ENABLED`) or disabled (`DISABLED`) for tables in this tablespace
`DEF_INMEMORY_PRIORITY`²	`VARCHAR2(8)`		Indicates the default priority for In-Memory Column Store (IM column store) population for this tablespace. Possible values: `LOW` `MEDIUM` `HIGH` `CRITICAL` `NONE` `NULL`
`DEF_INMEMORY_DISTRIBUTE`²	`VARCHAR2(15)`		Indicates how the IM column store is distributed by default for this tablespace in an Oracle Real Application Clusters (Oracle RACE) environment: `AUTO` `BY ROWID RANGE` `BY PARTITION` `BY SUBPARTITION`
`DEF_INMEMORY_COMPRESSION`²	`VARCHAR2(17)`		Indicates the default compression level for the IM column store for this tablespace: `NO MEMCOMPRESS` `FOR DML` `FOR QUERY [ LOW \| HIGH ]` `FOR CAPACITY [ LOW \| HIGH ]` `NULL`
`DEF_INMEMORY_DUPLICATE`²	`VARCHAR2(13)`		Indicates the duplicate setting for the IM column store in an Oracle RAC environment: `NO DUPLICATE` `DUPLICATE` `DUPLICATE ALL`