Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

Tablespace's Utilization Report from OEM 12c/13c

The below query does not provide accurate results for the Tablespace PCT_used.

Need to correct this report to accurately reflect auto extensible tablespaces. Is there any query to get the Tablespace's Utilization Report based on AUTOEXTEND values?

Please suggest.

FYI,

select c.target_name,c.key_Value as "TABLESPACE_NAME"

from sysman.MGMT$METRIC_CURRENT c, sysman.MGMT$GROUP_MEMBERS g

where c.target_name not in (select TARGET_NAME from OEM_TARGET_NAMES) 

and c.target_type='oracle_database'

and c.column_label='Tablespace Space Used (%)'

and c.target_name=g.target_name

and c.target_type=g.target_type

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