DBA Tablespace usage

Description
Categories: Toolkit - DBA
Columns: Tablespace Name, Free Space Mb, Used Space Mb, Tablespace Size Mb, Used Percent ...
Queries tablespaces space usage and sorts tablespaces by used space percent in a descending order
select
tablespace_name "Tablespace Name",
((tablespace_size-used_space)*(select value from v$parameter where name = 'db_block_size'))/(1024*1024) "Free Space Mb",
(used_space*(select value from v$parameter where name = 'db_block_size'))/(1024*1024) "Used Space Mb",
(tablespace_size*(select value from v$parameter where name = 'db_block_size'))/(1024*1024) "Tablespace Size Mb",
used_space/tablespace_size*100 "Used Percent"
from
dba_tablespace_usage_metrics
order by used_percent desc