select tablespace_name , (free_blocks*8)/1024/1024  FreeSpaceInGB,
(used_blocks*8)/1024/1024  UsedSpaceInGB,
(total_blocks*8)/1024/1024  TotalSpaceInGB
from v$sort_segment where tablespace_name like '%TEMP%' 
 5  ;

SQL> select sh.tablespace_name,
2 'TEMP',
3 SUM(sh.bytes_used+sh.bytes_free)/1024/1024 total_mb,
4 SUM(sh.bytes_used)/1024/1024 used_mb,
5 SUM(sh.bytes_free)/1024/1024 free_mb,
6 ROUND(SUM(sh.bytes_used)/SUM(sh.bytes_used+sh.bytes_free)*100,2) pct_used,
7 '['||DECODE(SUM(sh.bytes_free),0,'XXXXXXXXXXXXXXXXXXXX',
8 NVL(RPAD(LPAD('X',(TRUNC(ROUND((SUM(sh.bytes_used)/SUM(sh.bytes_used+sh.bytes_free))*100,2)/5)),'X'),20,'-'),
9 '--------------------'))||']'
10 FROM v$temp_space_header sh
11 GROUP BY tablespace_name
12 --order by TOTAL_mb desc
13 order by pct_used desc
14 ;

V$TEMP_SPACE_HEADER
This view displays aggregate information per file per LOCALLY MANAGED temporary tablespace regarding how much space is currently being used and how much is free as identified in the space header.

V$SORT_SEGMENT
This view contains information about every sort segment in a given instance.