SELECT alloc.TARGET_NAME,TO_DATE(TO_CHAR(alloc.timestamp, 'MON RR'), 'MON RR') AS CALENDAR_MONTH, alloc.tablespace AS TABLESPACE, round(avg(alloc.avg_size_mb), 2) AS SIZE_MB, round(avg(used.avg_used_mb), 2) AS USED_MB, round(avg(alloc.avg_size_mb - used.avg_used_mb), 2) AS FREE_MB, round(avg((used.avg_used_mb*100)/ decode(alloc.avg_size_mb, 0, 1, alloc.avg_size_mb)), 2) AS USED_PCT, round(max(alloc.max_size_mb), 2) AS SIZE_MAX_MB, round(max(used.max_used_mb), 2) AS USED_MAX_MB, round(max(alloc.avg_size_mb - used.avg_used_mb), 2) AS FREE_MAX_MB, round(max((used.avg_used_mb*100)/decode(alloc.avg_size_mb, 0, 1, alloc.avg_size_mb)), 2) AS USE...
Comments
Post a Comment