Table space usage Query

Select a. file_id file number,
A. tablespace_name tablespace name,
B. file_name physical file name,
B. autoextensible auto scaling,
B. maxbytes/1024/1024/1024 Max space G,
Total/1024/1024 tablespace MB,
Free/1024/1024 MB remaining,
(Total-free)/1024/1024 MB,
Round (total-free)/total, 4) * 100 "usage % ",
'Alter database datafile' | file_name | ''' resize 5120 m; 'SQL statement for extended tablespace
From (select file_id, tablespace_name, sum (bytes) free
From dba_free_space
Group by file_id, tablespace_name),
(Select file_id, tablespace_name, autoextensible, file_name, maxbytes, sum (bytes) Total
From dba_data_files
Group by tablespace_name, file_id, autoextensible, file_name, maxbytes) B
Where a. tablespace_name = B. tablespace_name
And a. file_id = B. file_id
Order by 1;