FRA USED & FREE SPACE

SQL> select name, floor(space_limit/1024/1024) "Size MB",ceil(space_used/1024/1024) "Used MB"             from v$recovery_file_dest order by name;

NAME          Size MB          Used MB
---------- ---------- -----------------------
+RECO          500000             1369


SQL> select (case when percent_used>100 then 0 else (100-percent_used) end) percent_free
  2  from (select(sum(percent_space_used)- sum (percent_space_reclaimable)) percent_used from
  3  v$flash_recovery_area_usage);

PERCENT_FREE
------------
       99.82

Happ Learning ...