Oracle查看数据库空间使用情况

select  fs.tablespace_name,
        df.file_name ,
        df.bytes "Total Bytes",
        df.blocks "DB Blocks",
        sum(fs.bytes) "Bytes Free",
        (100*((sum(fs.bytes))/df.bytes)) "% Free",
        df.bytes-sum(fs.bytes) "Bytes Used",
    (100*((df.bytes-sum(fs.bytes))/df.bytes)) "% Used"
from sys.dba_data_files df, sys.dba_free_space fs
where df.file_id(+) = fs.file_id
group by fs.tablespace_name, df.file_name, df.bytes, df.blocks
order by fs.tablespace_name, df.file_name;