How to get the FRA details through OEM
I want to know FRA details thorugh OEM so used the below query,
with a as (SELECT
case when metric_column='flash_recovery_area' then value else ' ' end FRA_NAME,
case when metric_column='flash_recovery_area_size' then VALUE/1024/1024 else 0 end FRA_SIZE,
case when metric_column='usable_area' then VALUE else '0' end FREE_SPACE,
case when metric_column='nonreclaimable_area' then VALUE else '0' end USED_SPACE
FROM sysman.mgmt$metric_current where metric_column in ('flash_recovery_area_size','usable_area','nonreclaimable_area','flash_recovery_area')
and target_name='xxx')
select fra_name,sum(fra_size),sum(free_space),sum(used_space) from a group by fra_name;