To get the TEMPFILES SIZE from the database

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