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 12.1.0.1.0 to 12.1.0.3.0 [Release 12.1]
Information in this document applies to any platform.

Goal

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

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

Solution

	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

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.