My Oracle Support Banner

Troubleshooting a Database Tablespace Space Used(%) Alert problem in Enterprise Manager 10g, 11g Grid Control and Database Control (Doc ID 403264.1)

Last updated on FEBRUARY 15, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 10.1.0.2 to 11.1.0.7 [Release 10.1 to 11.1]
Oracle Database - Enterprise Edition - Version 9.0.1.5 to 11.1.0.7 [Release 9.0.1 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.

Purpose

This article intends to describe the steps necessary to troubleshoot a problem with a Database Tablespace Used(%) Metric in Enterprise Manager (10g Grid Control or 10g and 11g Database Control) that is either not raising or clearing when it should.

NOTE: For a summary of Oracle Recommended Patches For Tablespace Monitoring using the Tablespace Space Used % metric, refer to <Note 849498.1>

ATTENTION: Enterprise Manager 10g and 11g are now beyond premier support. Oracle strongly recommends that you upgrade your environment to either Enterprise Manager 12c or 13c, both of which are still in Premier Support. If you would like to discuss Tablespace Used (%) metric errors with other EM Users or with EM Support, please feel free to monitor or update MOS discussion thread.

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
 Determining the type of alert that the problem is related to
 Investigation steps for 10g and above Locally Managed Tablespaces
 Investigation steps for pre-10g tablespaces and Dictionary Managed Tablespaces
References

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