DBA_TABLESPACE_USAGE_METRICS does not list all the expected tablespaces
(Doc ID 2068817.1)
Last updated on JUNE 15, 2018
Applies to:Enterprise Manager for Oracle Database - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
The view DBA_TABLESPACE_USAGE_METRICS does not show all the expected tablespaces. For example,
returns the names of the tablespaces that exist in dba_data_files but which are not shown in dba_tablespace_usage_metrics.
Note that Enterprise Manager Cloud Control relies on the DBA_TABLESPACE_USAGE_METRICS view. If tablespaces are missing from this view, then it will not be possible for Enterprise Manager to raise alerts via the Tablespace Space Full (%) metric.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!