Database Administration (MOSC)

MOSC Banner

Tablespace not showing up in dba_tablespace_usage_metrics VIEW

edited Jun 4, 2016 5:04AM in Database Administration (MOSC) 6 commentsAnswered

Hi

We have a 11.2.0.3 database on linux

We have observed that the view "dba_tablespace_usage_metrics" is NOT showing some of the tablespaces

For example, here are 3 tablespaces as reported by dba_Tablespaces

Select * from dba_tablespaces where tablespace_name like 'APP%'

APPQUE 8192 65536 1 2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO

APPQUEIDX 8192 65536 1 2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO

APPQUESUMMARY 8192 65536 1 2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO

But when we query dba_tablespace_usage_metrics, it shows nothing

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center