Database Administration (MOSC)

MOSC Banner

v$temp_space_header and dba_temp_free_space providing different data

edited Dec 1, 2014 10:06AM in Database Administration (MOSC) 3 commentsAnswered

Guys,

SQL> select * from v$temp_space_header

TABLESPACE_NAME                                                 FILE_ID BYTES_USED BLOCKS_USED BYTES_FREE BLOCKS_FREE RELATIVE_FNO

------------------------------------------------------------ ---------- ---------- ----------- ---------- ----------- ------------

TEMP1                                                                 1 3.4359E+10     4194176          0           0            1

TEMP2                                                                 2    1048576         128 3220176896      393088            1

SQL> sselect

SQL> select * from dba_temp_free_space;

TABLESPACE_NAME                                              TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE

------------------------------------------------------------ --------------- --------------- ----------

TEMP1                                                             3.4359E+10      3.4359E+10 2.7746E+10

TEMP2                                                             3221225472         1048576 3220176896

Why there is so much difference between output from both views

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