eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.USER_TABLESPACES

Object Details

Object Name:	USER_TABLESPACES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Description of accessible 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			Default maximum number of extents
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
SEGMENT_SPACE_MANAGEMENT	VARCHAR2	(6)		Segment space management tracking: "AUTO" or "MANUAL"
DEF_TAB_COMPRESSION	VARCHAR2	(8)		Default table 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
,      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.USER_TABLESPACES;

Dependencies

[top of page]

SYS.USER_TABLESPACES references the following:

SYS: TS$; TSQ$

SYS.USER_TABLESPACES is referenced by following:

PUBLIC: USER_TABLESPACES
SYS: DBMS_STREAMS_TBS_INT_INVOK - show dependent code; PRVT_COMPRESSION - show dependent code