cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Custom Alert - Flash Recovery Area Space Free

INTRODUCTION

This alert will utilize the V$RECOVERY_FILE_DEST view to calculate free space for each recovery area. By default it will send a critical email when there is less than 5% free space and a warning email when the free space is between 5-10%. If there are multiple recovery areas, this alert will return all that are running low on free space.


ALERT DEFINITION

To create this alert, click on Alerts > Manage Alerts tab and create a Custom SQL Alert with Multiple Numeric Return type. Configure the alert similar to below:


Alert Name: Monitor Flash Recovery Area Free Space

Execution Interval: 10 Minutes

Notification Text: The following flash recovery areas in this instance is running low on free space.

SQL Statement:

SELECT NAME, 100-ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1) PCT_FREE

FROM V$RECOVERY_FILE_DEST

Execute Against: Monitored Instance

Units: Percent Free

High Threshold: Min 0, Max 5

Medium Threshold: Min 5, Max 10

Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎04-22-2014 01:12 PM
Updated by: