Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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.
1 2 3 4 5 6 7 8 9 10 11 12 13 | 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; |
