오라클 asm disk 조회

ASM 디스크 조회

select 
  GROUP_NUMBER DG#, 
  name, 
  ALLOCATION_UNIT_SIZE AU_SZ, 
  STATE,
  TYPE, 
  TOTAL_MB, 
  FREE_MB,
  ROUND((NVL(FREE_MB, 0) / TOTAL_MB) * 100,2) AS FREE_RATE,
  OFFLINE_DISKS 
from v$asm_diskgroup;