Database Administration (MOSC)

MOSC Banner

tablespaces in dba_tablespace_usage_metrics not visible? select * from dba_tablespace_usage_metric

edited Mar 19, 2014 12:00PM in Database Administration (MOSC) 2 commentsAnswered

i have some table spaces created and existing

SYS[dbxxx]> select * from v$tablespace;

       TS# NAME                           INC BIG FLA ENC

---------- ------------------------------ --- --- --- ---

         0 SYSTEM                         YES NO  YES

         1 SYSAUX                         YES NO  YES

         2 UNDOTBS1                       YES NO  YES

         4 USERS                          YES NO  YES

         3 TEMP                           NO  NO  YES

         5 UNDOTBS2                       YES NO  YES

         6 STANDARD                       YES NO  YES

         7 TSEXT10M                       YES NO  YES

         8 TSEXT01M                       YES NO  YES

         9 JATO                           YES NO  YES

        10 TSMVLOG                        YES NO  YES

        11 SXBI                           YES NO  YES

        12 MPC                            YES NO  YES

13 Zeilen ausgew▒hlt.

but these table spaces are not visisble in dba_tablespace_usage_metrics. why ?

SYS[dbxxx]>select tablespace_id, rfno from v$filespace_usage;

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