View the brief storage status of a tablespace in ORACLE

Check the brief storage status of the tablespace without selectb. tablespace_name tablespace name, round (B. all_byte) total space (M), round (B. all_byte-a.free_byte) used (M), round (. free_byte) remaining space, round (. free_byteb.all_byte) * 100) | % percentage remaining from (selecttable

Check the brief storage status of the tablespace without selecting B. tablespace_name "tablespace name", round (B. all_byte) "total space (M)", round (B. all_byte-a.free_byte) "used (M)", round (. free_byte) "available space", round (. free_byte/B. all_byte) * 100) | '%' "percentage remaining" from (select table

View the brief storage status of a tablespace <无>

Select B. tablespace_name "tablespace name", round (B. all_byte) "total space (M)", round (B. all_byte-a.free_byte) "used (M)", round (. free_byte) "available space", round (. free_byte/B. all_byte) * 100) | '%' "percentage remaining" from (select tablespace_name, sum (nvl (bytes, 0)/1024/1024 free_byte from dba_free_space group by tablespace_name), (select tablespace_name, sum (nvl (bytes, 0)/1024/1024 all_byte from dba_data_files group by tablespace_name) bwhere B. tablespace_name =. tablespace_name (+) order by 1, 5;