DBA_TEMP_FREE_SPACE incorrect values in RAC database
Hi,
the size of the temporary tablespace in a two node rac database is duplicated on the view DBA_TEMP_FREE_SPACE.
I'm missing something ?
SQL> select * from DBA_TEMP_FILES;
FILE_NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
---------- ------------------------------ ---------- ---------- --------- ------------ --- ---------- ---------- ------------ ---------- -----------
/oradata/temp_01.dbf
1 TEMP 4293918720 524160 AVAILABLE 1 NO 0 0 0 4292870144 524032
/oradata/temp_02.dbf
2 TEMP 4293918720 524160 AVAILABLE 2 NO 0 0 0 4292870144 524032
SQL> select * from DBA_TEMP_FREE_SPACE;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
------------------------------ --------------- --------------- ----------
TEMP 17175674880 16991125504 8678014976
They should both return 8 GB which is the actual size of the temporary tablespace.