Tablespace Size Calculation

[moff]

Try the following....

To display the total size (in Mb) of each tablespace try :-

select tablespace_name, sum(bytes/(1024*1024)) "Total Mb"
from dba_data_files
group by tablespace_name;

To display the free space within a tablespace try :-

select tablespace_name,sum(bytes/(1024*1024)) "Free Mb"
from dba_free_space
group by tablespace_name

Tod display the biggest free extent in each tablespace try :-

select tablespace_name,max(bytes/(1024*1024)) "Biggest Free extent Mb"
from dba_free_space
group by tablespace_name


Cheers
Moff.