Oracle tablespace query settings

Oracle tablespace query settings select s. tablespace_name, round (sum (s. bytes/1024/1024), 2) as Space, round (sum (s. bytes/1024/1024)-nvl (d. fr, 0), 2) used, nvl (round (d. fr, 2), 0) free, decode (round (sum (s. maxbytes/1024/1024/1024), 2), 0, 'No', 'yes') auto_extend, round (sum (s. maxbytes/1024/1024/1024), 2) MaximumGB from dba_data_files s, (select c. tablespace_name, round (sum (c. bytes/1024/1024), 2) fr from dba_free_space c group by c. tablespace_name) d where s. tablespace_name = d. tablespace_name (+) group by s. tablespace_name, d. fr order by s. tablespace_name; www.2cto.com -- alter TABLE space size alter database datafile 'd: \ app \ user \ oradata \ common_data.dbf' resize 10240 M; -- set to automatically add 1G alter database datafile 'd: \ app \ user \ oradata \ COMMON_DATA.dbf 'autoextend on next 1024 m;