SQL Script to Find out ASM Disk Details

Here is the SQL script to find out ASM Disk Details.

set pages 10000 lines 250 
column path format a55

select path, group_number group_#, disk_number disk_#, mount_status,      
header_status, state, total_mb, free_mb 
from v$asm_disk 
order by group_number;

Sample Output

PATH                                                       GROUP_#     DISK_# MOUNT_S HEADER_STATU STATE      TOTAL_MB    FREE_MB
------------------------------------------------------- ---------- ---------- ------- ------------ -------- ---------- ----------
xxx/DATA_CD_08_xxxxxxxxxx                                        1         64 CACHED  MEMBER       NORMAL      4479008     902352
xxx/DATA_CD_06_xxxxxxxxxx                                        1         65 CACHED  MEMBER       NORMAL      4479008     902616
xxx/DATA_CD_09_xxxxxxxxxx                                        1         66 CACHED  MEMBER       NORMAL      4479008     902668
xxx/DATA_CD_05_xxxxxxxxxx                                        1         67 CACHED  MEMBER       NORMAL      4479008     902740
xxx/DATA_CD_02_xxxxxxxxxx                                        1         68 CACHED  MEMBER       NORMAL      4479008     902564