5_Free_Space_Tablespace.sql

5_Free_Space_Tablespace.sql

set pagesize 1000

column livre format 9999999.99
column tamanho format 9999999.99
column pct_free format 999.99
break on report
compute sum of tamanho on report
compute sum of livre on report

select free_tbs tablespace_name, free_size livre, tam_size tamanho, free_size/(tam_size)*100 pct_free
from (
select tablespace_name tam_tbs, sum(bytes)/(1024*1024) tam_size
from dba_data_files
group by tablespace_name), (
select tablespace_name free_tbs, sum(bytes)/(1024*1024) free_size
from dba_free_space
group by tablespace_name)
where free_tbs = tam_tbs
order by free_tbs;

clear computes
clear breaks
clear columns