My Oracle Support Banner

Understanding the role of the Server Generated Alert System in the evaluation of the Tablespace Space Full (%) metric in Enterprise Manager 12c Cloud Control and Grid Control (Doc ID 1928592.1)

Last updated on APRIL 04, 2019

Applies to:

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


To understand how the 'Tablespace Space Full (%)' metric is evaluated in Enterprise Manager Cloud Control and previous versions (eg. Grid Control).  Note that this article will *not* apply to Enterprise Manager Cloud Control (with database plug-in) onwards.

For details on Enterprise Manager onwards, see <Note:1927636.1> "Testing and Troubleshooting the 'Tablespace Space Full (%)' metric in Enterprise Manager"


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
 How to check whether the expected alert is showing in dba_outstanding_alerts 
 Action to take
 i) If the tablespaces have crossed the thresholds, but they are not showing in dba_outstanding_alerts
 ii) If the thresholds set on the database (in sys.dba_thresholds) and the thresholds set in Enterprise Manager do not match
 iii) If the thresholds are correct (in EM and on the database) and the alert shows in dba_outstanding_alerts but no alert is received
 A) Confirm whether critical or warning alerts are shown in 'open metric events'
 B) Check whether the agent knows the correct severity of the alert
 iv) If an alert shows in the console, but the alert condition no longer exists on the database.
 v) If the Tablespace Space Full(%) Values reported in the Enterprise Manager Alert, seem wrong
 vi) Useful Troubleshooting Notes

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