Tablespaces Missing From Tablespace Full% Metrics (Doc ID 1590391.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.0.1 version, Target Database, Listener, ASM

ACTUAL BEHAVIOR
---------------

When go to database home page -> all metrics -> Tablespace sapce used % 

Some of the temporary tablespaces do not exist. 


The metric responsible on getting these table spaces used the following query :-


SELECT m.tablespace_name,
                      m.used_percent,
                      (m.tablespace_size - m.used_space)*t.block_size/1024/1024 mb_free
        FROM  dba_tablespace_usage_metrics m, dba_tablespaces t, v$parameter p
        WHERE p.name='statistics_level' and p.value!='BASIC'
        AND t.tablespace_name = m.tablespace_name


By running this query manually , it misses also these tablespaces.

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