Easiest way to check tablespace utilization in Oracle Database.
This video describes about dba_tablespace_usage_metrics which can be used to check tablespace utilization.
---------------------------------------------------------------------------------------------------------------------------
--Script
select tablespace_name,used_space*8192/1024/1024 used_mb, tablespace_size*8192/1024/1024 size_mb,used_percent from dba_tablespace_usage_metrics order by used_percent;
---------------------------------------------------------------------------------------------------------------------------
#oracle #Tablespaceutilization #database #checktablespaceutilization #tablespaceutilizationquery #tablespaceutilizationscript