EM 10G and 11G - Database Tablespace Full Metric Alerts not Generated In Grid Control
Last updated on JANUARY 13, 2018
Applies to:Enterprise Manager for Oracle Database - Version 10.2.0.1 to 18.104.22.168 [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 ?
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.
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