View the usage of Oracle tablespace

1   Select  2 B. File_id  File ID,  3   B. tablespace_name: name of the tablespace,  4 B. bytes /  1024  /  1024   |  '  MB  ' Number of bytes,  5 (B. bytes -  Sum (Nvl (A. bytes, 0 ))) /  1024  /  1024   |  '  MB  '  Used,  6  Sum (Nvl (A. bytes, 0 )) /  1024  /  1024   |  '  MB  '  Remaining space,  7  Sum (Nvl (A. bytes, 0 )) / (B. bytes) *  100   |  '  %  '  Percentage remaining  8  From  Dba_free_space A, dba_data_files B  9  Where A. File_id  = B. File_id 10  Group   By B. tablespace_name, B. File_id  , B. bytes  11  Order   By B. File_id