My Oracle Support Banner

EM 12c: False Tablespace Space Used (%) Metric Alert is Received from Enterprise Manager 12c Cloud Control Every Day after the Database Blackout Ends (Doc ID 2020997.1)

Last updated on SEPTEMBER 14, 2021

Applies to:

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

Symptoms

A false Tablespace Space Used (%) metric alert is received every day after the database blackout ends.

For example:

EM Event: Critical:orcl - Tablespace TOOLS is 85 percent full
Host=<HOSTNAME>.<DOMAIN_NAME>
Target type=Database Instance
Target name=<INSTANCE NAME>
Categories=Capacity
Message=Tablespace TOOLS is 85 percent full
Event Type=Metric Alert
Event name=problemTbsp:pctUsed
Metric Group=Tablespaces Full
Metric=Tablespace Space Used (%)

However the tablespace is not full, nor has it been during the duration of the blackout.  There is no alert in dba_outstanding_alerts, and selecting from dba_alert_history shows that there has been no genuine alert for the period while the database was blacked out.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References

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