Verifica Tamanho Tablespaces

set pages 2000;
set lines 2000;
col TABLESPACE_NAME for a30;
col FILE_NAME for a60;
col AUTOEXTEN for a60;
select     tablespace_name, file_id, file_name, ((bytes/1024)/1024) as TAMANHOMB, ((maxbytes/1024)/1024) as MAXMB, autoextensible, ((increment_by/1024)/1024) as INCMB from dba_data_files order by 1,3,5;




conn / as sysdba
set lines 2000;
col TABLESPACE_NAME for a30;
col FILE_NAME for a60;
col AUTOEXTEN for a60;
select     file_id, tablespace_name, file_name, ((bytes/1024)/1024) as TAMANHOMB, ((maxbytes/1024)/1024) as MAXMB, autoextensible, ((increment_by/1024)/1024) as INCMB from dba_data_files order by 1,2,4;



set lines 2000;
col TABLESPACE_NAME for a30;
col FILE_NAME for a60;
col AUTOEXTEN for a60;
select    
    tablespace_name,
    file_name,
    ((bytes/1024)/1024) as TAMANHOMB,
    ((maxbytes/1024)/1024) as MAXMB,
    autoextensible,
    ((increment_by/1024)/1024) as INCMB
from
    dba_data_files

order by 1,2,4;