DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_TABLESPACES

Object Details
Object Name: DBA_TABLESPACES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Description of all tablespaces

[View Source]

Columns
Name Datatype Length Mandatory Comments
TABLESPACE_NAME VARCHAR2 (30) Yes Tablespace name
BLOCK_SIZE NUMBER
Yes Tablespace block size
INITIAL_EXTENT NUMBER

Default initial extent size
NEXT_EXTENT NUMBER

Default incremental extent size
MIN_EXTENTS NUMBER
Yes Default minimum number of extents
MAX_EXTENTS NUMBER

MAX_SIZE NUMBER

Default maximum size of segments
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
FORCE_LOGGING VARCHAR2 (3)
Tablespace force logging mode
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)
SEGMENT_SPACE_MANAGEMENT VARCHAR2 (6)
Segment space management tracking: "AUTO" or "MANUAL"
DEF_TAB_COMPRESSION VARCHAR2 (8)
Default compression enabled or not: "ENABLED" or "DISABLED"
RETENTION VARCHAR2 (11)
Undo tablespace retention: "GUARANTEE", "NOGUARANTEE" or "NOT APPLY"
BIGFILE VARCHAR2 (3)
Bigfile tablespace indicator: "YES" or "NO"
PREDICATE_EVALUATION VARCHAR2 (7)
Predicates evaluated by: "HOST" or "STORAGE"
ENCRYPTED VARCHAR2 (3)
Encrypted tablespace indicator: "YES" or "NO"
COMPRESS_FOR VARCHAR2 (30)
Default compression for what kind of operations
DEF_INMEMORY VARCHAR2 (8)
Default in-memory attribute
DEF_INMEMORY_PRIORITY VARCHAR2 (8)
Default priority in which in-memory column store objects are loaded
DEF_INMEMORY_DISTRIBUTE VARCHAR2 (15)
Default for how in-memory columnar store objects are distributed
DEF_INMEMORY_COMPRESSION VARCHAR2 (17)
Default compression level for the in-memory column store option
DEF_INMEMORY_DUPLICATE VARCHAR2 (13)
Default for how in-memory column store objects are duplicated
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TABLESPACE_NAME
,      BLOCK_SIZE
,      INITIAL_EXTENT
,      NEXT_EXTENT
,      MIN_EXTENTS
,      MAX_EXTENTS
,      MAX_SIZE
,      PCT_INCREASE
,      MIN_EXTLEN
,      STATUS
,      CONTENTS
,      LOGGING
,      FORCE_LOGGING
,      EXTENT_MANAGEMENT
,      ALLOCATION_TYPE
,      PLUGGED_IN
,      SEGMENT_SPACE_MANAGEMENT
,      DEF_TAB_COMPRESSION
,      RETENTION
,      BIGFILE
,      PREDICATE_EVALUATION
,      ENCRYPTED
,      COMPRESS_FOR
,      DEF_INMEMORY
,      DEF_INMEMORY_PRIORITY
,      DEF_INMEMORY_DISTRIBUTE
,      DEF_INMEMORY_COMPRESSION
,      DEF_INMEMORY_DUPLICATE
FROM SYS.DBA_TABLESPACES;

Dependencies

[top of page]

SYS.DBA_TABLESPACES references the following:

SchemaSYS
TableTS$
SYS.DBA_TABLESPACES is referenced by following:

SchemaDBSNMP
SynonymDBA_TABLESPACES
SchemaPUBLIC
SynonymDBA_TABLESPACES
SchemaSYS
ViewDBA_TABLESPACE_THRESHOLDS
Package BodyDBMS_AMD - show dependent code
Package BodyDBMS_AQADM_SYS - show dependent code
Package BodyDBMS_AUDIT_MGMT - show dependent code
Package BodyDBMS_AW - show dependent code
Package BodyDBMS_DBFS_SFS_ADMIN - show dependent code
ProcedureDBMS_FEATURE_AUM - show dependent code
ProcedureDBMS_FEATURE_AUTO_SSM - show dependent code
ProcedureDBMS_FEATURE_LMT - show dependent code
Package BodyDBMS_HEAT_MAP - show dependent code
Package BodyDBMS_PRVTAQIM - show dependent code
Package BodyDBMS_REPCAT_UTL4 - show dependent code
Package BodyDBMS_STREAMS_TBS_INT_INVOK - show dependent code
Package BodyDBMS_UNDO_ADV - show dependent code
Package BodyKUPC$QUE_INT - show dependent code
Package BodyPRVT_ACCESS_ADVISOR - show dependent code
TYPE BODYWRI$_ADV_OBJSPACE_TREND_T