[ASM] 디스크 정보 확인

ASM 디스크 사용량 및 가용공간 확인

 

SELECT name
     , type
     , required_mirror_free_mb
     , usable_file_mb
     , voting_files
     , (total_mb/DECODE(type,'HIGH',3,'NORMAL',2,'EXTERN',1)) AS "TOTAL(MB)"
     , (free_mb /DECODE(type,'HIGH',3,'NORMAL',2,'EXTERN',1)) AS "FREE(MB)"
     , ROUND(((free_mb/DECODE(type,'HIGH',3,'NORMAL',2,'EXTERN',1))/(total_mb/DECODE(type,'HIGH',3,'NORMAL',2,'EXTERN',1)))*100,2) AS "FREE(%)"
     , ROUND(100-(((free_mb/DECODE(type,'HIGH',3,'NORMAL',2,'EXTERN',1))/(total_mb/DECODE(type,'HIGH',3,'NORMAL',2,'EXTERN',1)))*100),2) AS "USAGE(%)"
  FROM v$asm_diskgroup
 WHERE SUBSTR(name,1,INSTR(name,'_')-1) IN (SELECT name FROM v$database);