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.
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.