[Home] [Help] [Dependency Information]
Object Name: | DBA_TABLESPACE_USAGE_METRICS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Description of all tablespace space usage metrics
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TABLESPACE_NAME | VARCHAR2 | (30) | Tablespace name | |
USED_SPACE | NUMBER | Total space consumed in the tablespace | ||
TABLESPACE_SIZE | NUMBER | Total size of the tablespace | ||
USED_PERCENT | NUMBER | % of used space, as a function of maximum possible tablespace size |
Cut, paste (and edit) the following text to query this object:
SELECT TABLESPACE_NAME
, USED_SPACE
, TABLESPACE_SIZE
, USED_PERCENT
FROM SYS.DBA_TABLESPACE_USAGE_METRICS;
|
|
|