DBA_TABLESPACE_USAGE_METRICS describes tablespace usage metrics for all types of tablespaces, including permanent, temporary, and undo tablespaces.

Column Datatype NULL Description
TABLESPACE_NAME VARCHAR2(30)   Tablespace name
USED_SPACE NUMBER   Total space consumed by the tablespace
TABLESPACE_SIZE NUMBER   Total size of the tablespace
USED_PERCENT NUMBER   Percentage of used space, as a function of the maximum possible tablespace size