6.58 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 the tablespace, in database blocks For undo tablespaces, the value of this column includes space consumed by both expired and unexpired undo segments. |
|
|
|
Tablespace size, in database blocks
|
|
|
|
Percentage of used space, as a function of the maximum possible tablespace size |