TABLESPACE INFORMATION NOTES

 

Information

TABLESPACE INFORMATION NOTES:

Tablespace Name - Name of the tablespace

Initial Extent - Default initial extent size

Next Extent - Default incremental extent size

Min Extents - Default minimum number of extents

Max Extents - Default maximum number of extents

PCT Increase - Default percent increase for extent size

Status - Tablespace status: ONLINE, OFFLINE, or INVALID (tablespace has been dropped)

Contents - Type of tablespace. This column will have 'TEMPORARY' (v7.3+) for dedicated temporary tablespaces, and 'PERMANENT' for tablespaces that can store both temporary sort segments and permanent objects.

select TABLESPACE_NAME,
 INITIAL_EXTENT,
 NEXT_EXTENT,
 MIN_EXTENTS,
 MAX_EXTENTS,
 PCT_INCREASE,
 STATUS,
 CONTENTS
from  dba_tablespaces
order  by TABLESPACE_NAME