EM 12c: Enterprise Manager 12c Cloud Control does not Alert the Tablespace Full (%) Metric for some Database Tablespaces (Doc ID 2183256.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.4.0 and later
Information in this document applies to any platform.

Symptoms

Enterprise Manager 12c Cloud Control does not alert the Tablespace Full (%) Metric for some 12c database tablespaces.

There is a difference in the results from these two queries, which should normally match (for example):

select tablespace_name from dba_tablespace_usage_metrics order by tablespace_name;

 21 FOO120
 22 FOO121
 23 FOO122
 24 FOO128
 25 FOO129
 26 FOO130

select tablespace_name from dba_tablespaces order by tablespace_name;

 21 FOO120
 22 FOO121
 23 FOO122
 24 FOO123
 25 FOO124
 26 FOO125
 27 FOO126
 28 FOO127
 29 FOO128
 30 FOO129
 31 FOO130

 

 

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms