List temporary tablepaces and their tempfiles

select t.file#,ts#,status,t.name "temp file name",n.name "tablespace name", n.bigfile,t.bytes/1024/1024 "Size MB"
from v$tempfile t join v$tablespace n
using(ts#);

FILE#	TS#	STATUS	temp file name	tablespace name	BIGFILE	Size MB
1	3	ONLINE	/u02/oradata/proddb01/temp01.dbf	TEMP	YES	256
2	66	ONLINE	/u02/oradata/proddb01/user_temp.dbf	USER_TEMP	YES	256
3	70	ONLINE	/u02/oradata/proddb01/temp_d1u_01.dbf	BATCH_TEMP	YES	256