DBA_TABLESPACES

This is a dynamic performance view equivalent to the SYS.TS$ table containing information on all tablespaces; the only difference is that DBA_TABLESPACES doesn't list dropped tablespaces.

Fields

The most relevant view fields are as follows:

• TABLESPACE_NAME: The name of the tablespace

• BLOCK_SIZE: The database block size used in the tablespace

• STATUS: This can be ONLINE, OFFLINE, or READ ONLY

• CONTENTS: This can be UNDO, PERMANENT, or TEMPORARY

• LOGGING: This can be LOGGING or NOLOGGING

• EXTENT_MANAGEMENT: This can be DICTIONARY for dictionary managed or LOCAL for locally managed tablespaces

• ALLOCATION_TYPE: This can be SYSTEM, USER, or UNIFORM