The only time you've really got to start worrying about this DB_AreaSpaceUtilizationHigh alert is if the Area in the alert is a TYPE I Storage Area, then it's down to the interpretation of percentages.
While this DB_AreaSpaceUtilizationHigh alert is simply saying that the HWM has breached x% of the total blocks, For TYPE I Storage Areas, you need be aware of the maxarea limit being approached (viz with a 4KB blocksize, that would be 256 GB for 32 rpb, 128 GB for 64 rpb, 64 GB for 128 rpb etc).
Otherwise, this DB_AreaSpaceUtilizationHigh alert is best useful when you ensure that it is acted upon before the variable extent is started to be used and add more FIXED extents + variable extent to accommodate anticipated growth, in order to raise the TOTAL BLOCKS. As a PERCENTAGE, the larger the area grows, the more free blocks need to be added in order for there to be a significant difference to halt the alert from being thrown. An alternative solution would be to turn off the alert and monitor the filesystem instead. |