Hi,
I am using Release 11.2.0.3.0 ,version of oracle, two node cluster. When i was trying to get the consumed and free temp space. But i ma getting contradicting values in two dictionarys.
For total allocated space, when i am querying dba_temp_files its giving me 212GB but in GV$tempfile its giving ~424Gb that is double. and when i checked the exact file names , i found for same file name or file there exists two records in GV$tempfiles with inst_id 1 and 2.
For getting total free space , when i query dba_temp_free_space, its giving result(free_space/1024/1024/1024) ~193GB. but in gv$sort_segment its giving me result 'SUM (used_blocks * block_size) / 1024 / 1024/1024' as .2 that is almost all the tempspace is free.
Which one is correct calculation?