How many Percent of ASM Disks are used?

dbtut

6 years ago

In some cases, we may need to know how many percent of the ASM disks are used. The following query shows the percentage of usage by grouping the disks in the ASM structure according to member information.

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;

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;