Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

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;

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