///////////TO CHECK DISKGROUP SPACE INFORMATION
SQL> SELECT name, free_mb/1024, total_mb/1024, free_mb/total_mb*100 as percentage FROM v$asm_diskgroup;
////////////////////IDENTIFY CANDIDATE DISK
SELECT
NVL(a.name, '[CANDIDATE]') as disk_group_name
, b.path as disk_file_path
, b.name as disk_file_name
, b.failgroup as disk_file_fail_group
FROM
v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number)
ORDER BY
a.name;
/////////////////////CHECK ASM FILE INFORMATION
select file_number , sum(bytes)/(1024*1024) from v$asm_file group by file_number;
SQL> SELECT name, free_mb/1024, total_mb/1024, free_mb/total_mb*100 as percentage FROM v$asm_diskgroup;
////////////////////IDENTIFY CANDIDATE DISK
SELECT
NVL(a.name, '[CANDIDATE]') as disk_group_name
, b.path as disk_file_path
, b.name as disk_file_name
, b.failgroup as disk_file_fail_group
FROM
v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number)
ORDER BY
a.name;
/////////////////////CHECK ASM FILE INFORMATION
select file_number , sum(bytes)/(1024*1024) from v$asm_file group by file_number;
