Oracle查看所有表空间使用情况 

 
 1 select 
 2   b.file_id FILEID, 
 3   b.tablespace_name TBSNAME, 
 4   b.bytes/1024/1024||'M' SIZES, 
 5   (b.bytes-sum(nvl(a.bytes,0)))/1024/1024||'M' USED, 
 6   sum(nvl(a.bytes,0))/1024/1024||'M' FREE, 
 7   100 - sum(nvl(a.bytes,0))/(b.bytes)*100||'%' PERCENTS 
 8 from dba_free_space a,
 9      dba_data_files b 
10 where a.file_id = b.file_id 
11 group by b.tablespace_name, b.file_id, b.bytes 
12 order by b.file_id;

posted @ 2011-11-29 22:41  shungdawei  阅读(987)  评论(0)  编辑  收藏  举报