Description
The current alert for Oracle Tablespace Freespace has limitations and I find this simple custom alert to work a bit better. It uses the system view named DBA_TABLESPACE_USAGE_METRICS (Oracle 11.2+) to calculate the free space remaining in all tablespaces. It includes both data and temp tablespaces as well and takes autoextend data files into account.
Alert Definition
To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert similar to below and use the attached script file for the SQL statement field:
