My Oracle Support Banner

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

Last updated on FEBRUARY 24, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.