Temp tablespace datafile

 SET LINESIZE 200

COLUMN file_name FORMAT A70

SELECT file_id,

       file_name,

       ROUND(bytes/1024/1024/1024) AS size_gb,

       ROUND(maxbytes/1024/1024/1024) AS max_size_gb,

       autoextensible,

       increment_by,

       status

FROM   dba_temp_files

ORDER BY file_name;