查看表空间使用情况

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