Version 2

    Description

    This alert 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 as 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.

     

    Alert Name: Tablespace Free Space

    Execution Interval: 1 Hour

    Notification Text: The following list of tablespaces have less than 5% free space remaining.

     

    SELECT tablespace_name, 100-used_percent

    FROM dba_tablespace_usage_metrics;

     

    Execute Against: Monitored Instance

    Units: % Free

    High Threshold: Min 5, Max empty

    Medium Threshold: Min 5, Max 10