View Oracle Table space usage ____oracle

Dba_free_space: Describes the remaining size of the data space

Dba_data_file: Describes the total size of the data table space

Select A.tablespace_name, A.bytes bytes_used, B.largest,round ((a.bytes-b.bytes)/a.bytes) *100,2) percent_used from ( Select tablespace_name,sum (bytes) bytes from Dba_data_files Group by Tablespace_name) A, (select Tablespace_name, sum (by TES) bytes, max (bytes) largest from Dba_free_space Group by Tablespace_name) b where a.tablespace_name = B.tablespace_name

Order by ((a.bytes-b.bytes)/a.bytes) DESC;

The table space needs to be enlarged when the table space is found to exceed 80%:

Alert tablespace ... add datafile