To get the TEMPFILES SIZE from the database - Oracle Consulting Services | USA | 99% Customer Retention

select tablespace_name,file_name,bytes/1024/1024
“SIZE_IN_MB” from dba_temp_files order by file_name asc;