Custom Alert - Flash Recovery Area Space Free

[#1]

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