How to list Oracle tempfiles

One-liner listing of every tempfile with its size, max size, autoextend flag, and status. First thing to check when TEMP is misbehaving or being resized.

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;