My Oracle Support Banner

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

Last updated on NOVEMBER 24, 2019

Applies to:

Enterprise Manager for Oracle Database - Version to [Release 10.2 to 11.1]
Information in this document applies to any platform.


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.





To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.