Difference dba_tablespace_usage_metrics & dba_temp_free_space
Hello,
Can you please explain me whet are the differences beetwen dba_tablespace_usage_metrics and dba_temp_free_space
When i query those two views, for TEMP tablespace, i have differents results :
SQL*Plus> select * from dba_tablespace_usage_metrics where tablespace_name = 'TEMP';
TABLESPACE_NAME USED_SPACE TABLESPACE_SIZE USED_PERCENT
------------------------------ ---------- ---------------- ------------
TEMP 3932032 3,932,160 99.9967448
SQL*Plus> select * from dba_temp_free_space
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
------------------------------ ---------------- ---------------- ----------------
TEMP 32,212,254,720 32,212,254,720 32,209,108,992
With dba_tablespace_usage_metrics, i have à 100% usage, but with dba_temp_free_space, i have 0%...
Regards,