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