[Home] [Help] [Dependency Information]
Object Name: | DBA_TABLESPACES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Description of all tablespaces
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 |
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;
|
|
|