What units are used in the usage metrics (USED_SPACE
and TABLESPACE_SIZE
columns) described in Oracle's DBA_TABLESPACE_USAGE_METRICS
static data dictionary view?
The Oracle Database Reference only tells they are the "Total space consumed by the tablespace" and "Total size of the tablespace", without mentioning units. Are they in bytes? Megabytes? Blocks?
Best Answer
Blocks. Blocks are the units of the
DBA_TABLESPACE_USAGE_METRICS.USED_SPACE
andDBA_TABLESPACE_USAGE_METRICS.TABLESPACE_SIZE
. The latter column accounts for possible AUTOEXTEND MAXSIZE.EDIT: I'm not sure what is the meaning of USED_SPACE for undo tablespace though. For example: