Calculate Freespace in ASM
Strange enough it is not obvious to what extent the freespace in an ASM-Diskgroup ist being used. The answer will always be: "It depends!". Here I'll provide a query that should give you numbers an a way that you'll be on the save side.
With the following query we monitor the space usage in our ASM diskgroups.
It will provide very conservative values to the account of how much space is left, so you will be on the save side.
select name as "DG NAME", decode(type, 'EXTERN',round(usable_file_mb/(total_mb)*100), 'NORMAL',round(usable_file_mb/(total_mb/2)*100), 'HIGH',round(usable_file_mb/(total_mb/3)*100)) as "% FREE SPACE" from v$asm_diskgroup order by 2 desc;
Previous:
Disable Oracle Password Security
