Saturday, September 24, 2016

Scripts to check the ASM disk and Diskgroup space details


select name,total_mb/1024,free_mb/1024 from v$asm_disk;

select name,total_mb/1024,free_mb/1024 from v$asm_diskgroup;

SELECT name, free_mb, total_mb, free_mb/total_mb*100 as Free   FROM v$asm_diskgroup;

select DISK_NUMBER,NAME,PATH,FAILGROUP,TOTAL_MB,FREE_MB from v$asm_disk;




No comments:

Post a Comment