How to check tablespace usage?
635106Oct 21 2008 — edited Oct 22 2008There are more than 5 datafiles associate with tablespace tabsp_1.
I want to check the usage of the tablespace,
select sum(bytes)/1024/1024 free_space_MB, tablespace_name
from dba_free_space
where tablespace_name='TABSP_1'
group by tablespace_name;
The the result seems a bit different with the output from Toad, Toad shows around 800MB free, but above script shows 850MB, which is 50M more.
Is my script correct? Thank you.