ASM磁盘空间查看（SQL）

整理了个asm磁盘空间的查看的sql，供大家参考，如有错误请不吝指教，感谢

set linesize 300 pagesize 1000
col "dg_name"    for a15
col "Total_GB"   for a10
col "Free_GB"    for a10
col "Used_GB"    for a10
col "USED%"      for a10


select dg.NAME "dg_name",
       (case
         when dg.type = 'HIGH' then
          TO_CHAR(dg.TOTAL_MB / 1024 / 3, '99999')
         when dg.type = 'NORMAL' then
          TO_CHAR(dg.TOTAL_MB / 1024 / 2, '99999')
         else
          TO_CHAR(dg.TOTAL_MB / 1024, '99999')
       end) "Total_GB",
       (case
         when dg.type = 'HIGH' then
          TO_CHAR(dg.FREE_MB / 1024 / 3, '99999')
         when dg.type = 'NORMAL' then
          TO_CHAR(dg.FREE_MB / 1024 / 2, '99999')
         else
          TO_CHAR(dg.FREE_MB / 1024, '99999')
       end) "Free_GB",
       TO_CHAR(dg.USABLE_FILE_MB / 1024, '99999') "Usable_GB",
       (case
         when dg.type = 'HIGH' then
          TO_CHAR(dg.COLD_USED_MB / 1024 / 3, '99999')
         when dg.type = 'NORMAL' then
          TO_CHAR(dg.COLD_USED_MB / 1024 / 2, '99999')
         else
          TO_CHAR(dg.COLD_USED_MB / 1024, '99999')
       end) "Used_GB",
       ROUND((dg.COLD_USED_MB / dg.TOTAL_MB) * 100) "USED%"
  from v$asm_diskgroup dg;