oracle如何查询表空间信息



select
b. file_name 物理文件名,
b.tablespace_name 表空间,
b.bytes / 1024 / 1024 大小M,
(b.bytes - sum (nvl(a.bytes, 0 ))) / 1024 / 1024   已使用M,
substr((b.bytes - sum (nvl(a.bytes, 0 ))) / (b.bytes) * 100 , 1 , 5 )  利用率
from dba_free_space a,dba_data_files b
where a. file_id = b. file_id
group by b.tablespace_name,b. file_name ,b.bytes
order by b.tablespace_name