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

_____________________________________________________________________________________________________________________

0 comments:

Post a comment

 

acehints.com Copyright 2011-20 All Rights Reserved | Site Map | Contact | Disclaimer