EM 10G and 11G - Database Tablespace Full Metric Alerts not Generated In Grid Control (Doc ID 357049.1)

Last updated on DECEMBER 18, 2015

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.1 to 11.1.0.1 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 16-Feb-2013***
Checked for relevance on 17-Jul-2014

Symptoms


The following symptoms are shown in the Grid Control :

(A) Unable to get an alert to fire for Tablespace Full % metric.
The Metric shows percent to be at 4.57 for the tablespace. Metric warning and critical set to 4 %.

(B) Unable to receive Alerts from Grid Control when the tablespace is showing up to 100% full. 

- Why are the Tablespace Full Alerts not working ? 
- How can we make the Tablespace Full Alerts work ?

Important Note:

1. Tablespace alerts are not generated by what is seen in :
Database Instance Home Page --> Administration --> Tablespaces

2. They are generated based on what you see in:
Database Instance Home Page --> All Metrics --> Tablespace Full --> Tablespace Space Used

Case 1 does not take into account maxsize, autoextend, or available disk space whereas Case 2 does. This is explained in detail below.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms