6 Replies Latest reply on Oct 22, 2008 4:53 AM by Enrique Orbegozo

    How to check tablespace usage?

      There 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.