Temp file wise usage:

Temp file wise usage:

set lines 152

col FILE_NAME for a30

col TABLESPACE_NAME for a10

col BYTES for a12

col MAXBYTES for a12

col AUT format a8

col STATUS for a10

select file_name,tablespace_name,bytes/1024/1024,maxbytes/1024/1024,autoextensible,status from dba_temp_files;