My Oracle Support Banner

Troubleshooting a "Database Tablespace Space Used (%)" Alert issue in 12c Cloud Control (Doc ID 1532334.1)

Last updated on FEBRUARY 14, 2023

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.1.0 to 12.1.0.8.0 [Release 12.1]
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 is intended to help troubleshooting a typical "Tablespace Space Used (%)" issue on a 12c Cloud Control system where the alert behavior is not the desired one (ie. alerts not raising or clearing correctly). 

Please note this article does not apply to Cloud Control 12.1.0.4 and higher.  For 12.1.0.4, 12.1.0.5 and 13c see:

<Note:1927636.1> "Testing and Troubleshooting the 'Tablespace Space Full (%)' metric in Enterprise Manager 12.1.0.4 and higher"

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
 Determine which party is at fault here
 Investigating the RDBMS side
 Investigating the EM side
 Known issues
References

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