ASM Disk Usage
SELECT target_name, diskgroup, MAX (DECODE (seq, 7, VALUE)) REDUNDANCY, MAX (DECODE (seq, 4, VALUE)) PERCENT_USED, MAX (DECODE (seq, 6, ceil(VALUE/1024))) TOTAL_GB, MAX (DECODE (seq, 9, ceil(VALUE/1024))) USABLE_TOTAL_GB, MAX (DECODE (seq, 3, ceil(VALUE/1024))) FREE_GB, MAX (DECODE (seq, 8, ceil(VALUE/1024))) USABLE_FREE_GB, MAX (DECODE (seq, 2, VALUE)) NO_OF_DISK, ceil(( MAX (DECODE (seq, 6, ceil(VALUE/1024)))) /(MAX (DECODE (seq, 2, … Read more