How to Check Tablespace Allocated Size and Free Size in SQL Developer

How to Check Tablespace in SQL

Below is the SQL Query to check for TableSpace in both GB(GigaBytes) & MB(MegaBytes) SQL Query To check Tablespace Allocated Size and Free Size in GB select b.tablespace_name, tbs_size SizeGB, a.free_space FreeGB from (select tablespace_name, round(sum(bytes)/1024/1024/1024,1) as free_space from dba_free_space group by tablespace_name UNION select tablespace_name, round((free_space)/1024/1024/1024,1) as   free_space from dba_temp_free_space) a, (select tablespace_name, sum(bytes)/1024/1024/1024 […]