SQL Script to Find out ASM Disk Details

advertisements

_____________________________________________________________________________________________________________________

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

_____________________________________________________________________________________________________________________

Website Stats