Tablespaces Missing From Tablespace Full% Metrics

(Doc ID 1590391.1)

Last updated on DECEMBER 06, 2016

Applies to:

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


On : version, Target Database, Listener, ASM


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.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'statistics_level' and p.value!='BASIC'
        AND t.tablespace_name = m.tablespace_name

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


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