TABLESPACE COM EXPANSÃO DE TAMANHO AUTOMÁTICO

[jspaulonciParticipante]

Moçada. segue um sql legal para monitorar o uso das tablespaces.

SELECT Total.name “TABLESPACE”,
round(nvl(Free_space, 0)) As “LIVRE(MB)”,
round(nvl(total_space-Free_space, 0)) As “USADO(MB)”,
round(total_space) As “TOTAL(MB)”,
round(round(nvl(total_space-Free_space, 0))/total_space*(100),2) “%ALOCADO”
FROM
(select tablespace_name, sum(bytes/1024/1024) Free_Space
from sys.dba_free_space
group by tablespace_name
) Free,
(select TABLESPACE_NAME As Name, sum(bytes/1024/1024) TOTAL_SPACE
from dba_data_files B
group by b.TABLESPACE_name
) Total
WHERE Free.Tablespace_name(+) = Total.name
ORDER BY Total.name