cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Custom Alert - Oracle Tablespace Free Space

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

Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎02-14-2019 08:47 AM
Updated by: