Verifica Temp Files

select FILE_ID,  FILE_NAME, TABLESPACE_NAME, (BYTES/(1024)/1024) as "ESPACO EM MB",  (MAXBYTES/(1024)/1024) as "MAXBYTES", STATUS, AUTOEXTENSIBLE, (INCREMENT_BY/(1024)) as "INCREMENTED_BY" from dba_temp_files order by 3, 2;


select FILE_ID,  FILE_NAME, TABLESPACE_NAME, (BYTES/(1024)/1024) as "ESPACO EM MB",  (MAXBYTES/(1024)/1024) as "MAXBYTES", STATUS, AUTOEXTENSIBLE, INCREMENT_BY from dba_temp_files order by 3, 2;