SELECT B.GROUP_NUMBER DISK_GROUP_NUMBER,
B.PATH DISK_FILE_PATH,
B.NAME DISK_FILE_NAME,
B.FAILGROUP DISK_FILE_FAIL_GROUP,
B.TOTAL_MB TOTAL_MB,
(B.TOTAL_MB - B.FREE_MB) USED_MB,
DECODE (B.TOTAL_MB,
0, 0,
(ROUND ( (1 - (B.FREE_MB / B.TOTAL_MB)) * 100, 2)))
PCT_USED
FROM V$ASM_DISK B
WHERE B.HEADER_STATUS = 'MEMBER'
ORDER BY B.GROUP_NUMBER;