Tags

This view is useful to provide tablespace usage for all the tablespace utilization, including temp, undo, data:

 

SQL> desc dba_tablespace_usage_metrics

Name                                      Null?    Type

TABLESPACE_NAME                                    VARCHAR2(30)
USED_SPACE                                         NUMBER
TABLESPACE_SIZE                                    NUMBER
USED_PERCENT                                       NUMBER

 

But we have few bugs with on this view as well, like the data inconsistent between dba_tablespace_usage_metrics and dba_tablespaces and dba_data_files. We see variant results in dba_tablespaces, and dba_tablespace_usage_metrics views. After initial analysis, I found it’s a BUG 21239530 but with medium severity.

So until the issue is fixed please use dba_tablespaces, v$filespace_usage , dba_free_space and other queries to monitor tablespace usage.

Bug 21239530 : DIFFERENCES IN DBA_TABLESPACES AND DBA_TABLESPACE_USAGE_METRICS

 

This bug is fixed in 12.2 version, so it affected all  lower versions.