6.48 DBA_TABLESPACE_USAGE_METRICS
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 all objects created in the tablespace, expressed as number of data blocks For undo tablespaces, the value of this column includes space consumed by both expired and unexpired undo segments. |
|
|
|
The maximum size of the tablespace, expressed as number of data blocks
|
|
|
|
Percentage of used space, as a function of the maximum possible tablespace size |