ASM Diskgroup Growth – Last 2 weeks

SELECT target_name,
         ROUND ( (MAX (AVERAGE) - MIN (AVERAGE)) / 14 / 1024 / 1024 / 1024/1024,2)
            AS GB
    FROM mgmt$metric_daily
   WHERE     target_name in (select target_name from mgmt_targets where target_type='osm_cluster')
         AND key_value like 'DATA%'
         AND column_label = 'Total Bytes'
         AND TRUNC (rollup_timestamp) >= TRUNC (SYSDATE) - 14
GROUP BY target_name;