Description
This alert will utilize the V$RECOVERY_FILE_DEST view to calculate free space for each recovery area. 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 as needed and past in the attached query.