Consulta Datafile Auto Extend



select file_id, tablespace_name, round(bytes/1024/1024) size_mb, blocks, autoextensible, increment_by, round(maxbytes/1024/1024) max_mb from dba_data_files; 


set lines 250
set pages 250
col FILE_NAME format a60
select file_name,tablespace_name,bytes/1024,AUTOEXTENSIBLE,status from dba_data_files order by tablespace_name;