BI Publisher (MOSC)

MOSC Banner

Can anyone provide query using mgmt$ view for tablespace reporting?

edited Jul 19, 2021 3:33PM in BI Publisher (MOSC) 3 commentsAnswered

Need to setup Report in a way that it provides list of tablespaces of all the targets discovered in EM above say threshold of 75% used.

Currently i am using below query but unable to modify it as per the requirement, please help :

select * from

   ( select target_name,KEY_VALUE NAME

  ,decode(column_label,'Tablespace Allocated Space (MB)' ,'total_space'

            ,'Tablespace Free Space (MB)','free_space'

            ,'Tablespace Used Space (MB)','used_space'

            ,column_label) as column_label

            ,value

    from sysman.mgmt$metric_current

   where COLUMN_LABEL IN('Tablespace Allocated Space (MB)','Tablespace Used Space (MB)','Tablespace Free Space (MB)')

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