本帖最后由 spain.yx 于 2009-12-15 11:04 编辑
查看表空间的使用率
select
a.tablespace_name "TABLESPACE",
sum(a.bytes)/1024/1024 "SUM(MB)",
sum(b.bytes)/1024/1024 "FREE(MB)",
sum(b.bytes)/sum(a.bytes)*100 "FREE(%)"
from
dba_data_files a,
dba_free_space b
where
a.file_id=b.file_id
group by
a.tablespace_name;
查看表空间的使用率
select
a.tablespace_name "TABLESPACE",
sum(a.bytes)/1024/1024 "SUM(MB)",
sum(b.bytes)/1024/1024 "FREE(MB)",
sum(b.bytes)/sum(a.bytes)*100 "FREE(%)"
from
dba_data_files a,
dba_free_space b
where
a.file_id=b.file_id
group by
a.tablespace_name;
编辑回复