My Oracle Support Banner

EM 12c: Troubleshooting The Metric Alert for Database Instance "Tablespace Space Used (%)" in Enterprise Manager 12c Cloud Control (Doc ID 1532004.1)

Last updated on JANUARY 18, 2023

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.1.0 to 12.1.0.3.0 [Release 12.1]
Enterprise Manager for Oracle Database - Version 10.2.0.5 and later
Information in this document applies to any platform.
Metric alert for Database Instance "Tablespace Space Used (%)" in Enterprise Manager 12c
Metric alert for Cluster Database "Tablespace Space Used (%)" in Enterprise Manager 12c

Purpose

This article intends to describe the steps necessary to troubleshoot a problem with a Database Tablespace Used (%) Metric in Enterprise Manager (EM) 12c Cloud Control with the Database Plug-in 12.1.x

This article covers the monitoring of Oracle Database release 10.2.0.5 and higher only.  Please note, this article only refers to Enterprise Manager Cloud Control 12.1.0.3 and lower.  for EM 12.1.0.4 Cloud Control and higher, see <Note:1927636.1> "Testing and Troubleshooting the 'Tablespace Space Full (%)' metric in Enterprise Manager 12.1.0.4"

This article will be useful for troubleshooting :-

Metric alert for Database Instance "Tablespace Space Used (%)"  in Enterprise Manager 12c

 

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 Background
 1. Get the current data from the relevant database views
 Query "Tablespaces Metric Threshold settings"
 Query "Tablespace Used(%) Current Value"
 Only for Oracle Database Release 11.1.x
 For all Oracle Database releases
 Query "Server Alert Subscribers"
 Query "Users with OEM_MONITOR ROLE"
 Query "OEM_MONITOR ROLE Dequeue Privilege on SYS.ALERT_QUE"
 Query "Number of Outstanding Messages in SYS.ALERT_QT"
 Query "Outstanding Alerts"
 Query "Tablespace Cleared Alerts History"
 2. Check the Cloud Control Agent
 Using the EMDIAG agtvfy kit
 Check the Tablespace metrics with the Cloud Control Agent Metric Browser
 Known Issues for Oracle Database Release 11.1
 If you have disabled the monitoring of a Tablespace and an Alert has not been cleared
 Bug - Server side TABLESPACE alerts are not cleared for DO_NOT_CHECK threshold
 Known Issues for Oracle database Release 11.2
References

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