Query Oracle Space Occupation

ALTER DATABASE datafile ' C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM. DBF ' Resize 4096M; SELECT used. Tablespace_name, used. Used_bytes as "used SPACE (in GB)", free. Free_bytes as "Free SPACE (in GB)" from (SELECT Tablespace_name,to_char (SUM (NVL (bytes,0))/1024/1024/1024, ' 99,999,990.99 ') as Used_bytes from User_segments GROUP by Tablespace_name) Usedinner JOIN (SELECT Tablespace_name,to_char (SUM (NVL (bytes,0))/1024/1024/1024, ' 99,999,990.99 ') As Free_bytes from User_free_space GROUP by Tablespace_name) Freeon (used. Tablespace_name = free. tablespace_name); Select Df.tablespace_name "Tablespace", totalusedspace "used MB", (Df.totalspace-tu.totalusedspace) ' Free MB ', Df.totalspace ' total MB ', round ((df.totalspace-tu.totalusedspace)/df.totalspace) "Pct. Free" from ( Select Tablespace_name,round (sum (bytes)/1048576) Totalspacefrom dba_data_files Group by Tablespace_name) DF, (select Round (sum (bytes)/(1024*1024)) Totalusedspace, Tablespace_namefrom dba_segments Group by Tablespace_name) Tuwhere DF.Tablespace_name = Tu.tablespace_name;

Query Oracle Space occupation