通过查看ASM磁盘组的容量以及所有表空间的使用情况，可以给往后的容量配置做准备预测。


----查看存储容量：
---查看v$asm_diskgroup视图

SQL> select group_number,name,total_mb,free_mb from v$asm_diskgroup;

GROUP_NUMBER NAME                             TOTAL_MB    FREE_MB

------------ ------------------------------ ---------- ----------

           1 DATA                                 5114       2685

---进入asmcmd查看：

grid@node1 > export ORACLE_SID=+ASM1

grid@node1 > asmcmd

ASMCMD> lsdg

State    Type    Rebal  Unbal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Name

MOUNTED  EXTERN  N      N         512   4096  1048576      5114     2685                0            2685              0  DATA/


----查看所有表空间的使用情况：
select t.*
  from (select d.tablespace_name,
               space "sum_space(m)",
               blocks sum_blocks,
               space - nvl(free_space, 0) "used_space(m)",
               round((1 - nvl(free_space, 0) / space) * 100, 2) "used_rate(%)",
               free_space "free_space(m)"
          from (select tablespace_name,
                       round(sum(bytes) / (1048576), 2) space,
                       sum(blocks) blocks
                  from dba_data_files
                 group by tablespace_name) d,
               (select tablespace_name,
                       round(sum(bytes) / (1048576), 2) free_space
                  from dba_free_space
                 group by tablespace_name) f
         where d.tablespace_name = f.tablespace_name(+)
        union all
        ----if have tempfile
        select d.tablespace_name,
               space "sum_space(m)",
               blocks sum_blocks,
               used_space "used_space(m)",
               round(nvl(used_space, 0) / space * 100, 2) "used_rate(%)",
               space - used_space "free_space(m)"
          from (select tablespace_name,
                       round(sum(bytes) / (1048576), 2) space,
                       sum(blocks) blocks
                  from dba_temp_files
                 group by tablespace_name) d,
               (select tablespace,
                       round(sum(blocks * 32768) / (1048576), 2) used_space
                  from v$sort_usage
                 group by tablespace) f
         where d.tablespace_name = f.tablespace(+)) t
 order by "used_rate(%)" desc;

---统计出来的数据：