Database Administration (MOSC)

MOSC Banner

Difference dba_tablespace_usage_metrics & dba_temp_free_space

edited Oct 4, 2016 5:00AM in Database Administration (MOSC) 4 commentsAnswered ✓

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center