SELECT FILE_NAME,FILE_ID,TABLESPACE_NAME,BYTES,STATUS,AUTOEXTENSIBLE,MAXBYTES,INCREMENT_BY FROM dba_temp_files
11.2
file_name | file_id | tablespace_name | bytes | status | autoextensible | maxbytes | increment_by |
/data/oracle/oradata/orcl/temp01.dbf | 1 | TEMP | 1880096768 | ONLINE | YES | 34359721984 | 80 |
10.2
file_name | file_id | tablespace_name | bytes | status | autoextensible | maxbytes | increment_by |
/data/oracle/oradata/orcl/temp01.dbf | 1 | TEMP | 3025141760 | AVAILABLE | YES | 34359721984 | 80 |
9.2
file_name | file_id | tablespace_name | bytes | status | autoextensible | maxbytes | increment_by |
/data/oracle/oradata/ora921/temp01.dbf | 1 | TEMP | 3357904896 | AVAILABLE | YES | 25769791488 | 17067 |