Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
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 |