DBA_TABLESPACE_USAGE_METRICS does not list all the expected tablespaces
Last updated on JUNE 15, 2018
Applies to:Enterprise Manager for Oracle Database - Version 18.104.22.168.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.
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