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 |
|
|
|
|
Total space consumed by the tablespace, in database blocks |
|
|
|
|
Maximum size of the tablespace, in database blocks |
|
|
|
|
Percentage of used space, as a function of the maximum possible tablespace size |