DBA Tablespace usage
Description
Categories: Toolkit - DBA
Columns: Tablespace Name, Free Space Mb, Used Space Mb, Tablespace Size Mb, Used Percent ...
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 |