表空间大小的查看和增加

select dbf.tablespace_name, 
dbf.totalspace "总量(M)", 
dbf.totalblocks as 总块数, 
dfs.freespace "剩余总量(M)", 
dfs.freeblocks "剩余块数", 
(dfs.freespace / dbf.totalspace) * 100 "空闲比例" 
from (select t.tablespace_name, 
sum(t.bytes) / 1024 / 1024 totalspace, 
sum(t.blocks) totalblocks 
from dba_data_files t 
group by t.tablespace_name) dbf, 
(select tt.tablespace_name, 
sum(tt.bytes) / 1024 / 1024 freespace, 
sum(tt.blocks) freeblocks 
from dba_free_space tt 
group by tt.tablespace_name) dfs 
where trim(dbf.tablespace_name) = trim(dfs.tablespace_name);

复制 搜索

复制 搜索