查看表空间使用情况

--1.查看表空间使用情况

select (tablespace_name) "表空间名",   
       sum(total_size) "总空间/M",   
       sum(total_free) "剩余空间/M",   
       sum(max_continue) "最大连续空间/M",   
       round(sum(total_free) / sum(total_size) * 100) "剩余百分比/ratio"  
  from ((select tablespace_name,   
                (0) total_size,   
                round(sum(bytes) / 1024 / 1024, 2) total_free,   
                round(max(bytes) / 1024 / 1024, 2) max_continue   
           from dba_free_space   
          group by tablespace_name) union all  
        (select tablespace_name, round(sum(bytes) / 1024 / 1024, 2), 0, 0   
           from dba_data_files   
          group by tablespace_name))   
 group by tablespace_name   
 order by 5 asc  

--2.查看各个对象的表空间使用情况

select t.owner,   
       t.segment_name,   
       t.segment_type,   
       sum(bytes) / (1024 * 1024) as "size(M)"  
  from dba_segments t   
 --where t.owner IN ('KRMDBA', 'BRMETL', 'ALMRPT')   
 group by t.segment_name, t.segment_type, t.owner