FRA STATUS ON ORACLE DATABASE

 set linesize 500
col NAME for a20
select name, ROUND(SPACE_LIMIT/1024/1024/1024,2) "Allocated Space(GB)",
round(SPACE_USED/1024/1024/1024,2) "Used Space(GB)",
round(SPACE_RECLAIMABLE/1024/1024/1024,2) "SPACE_RECLAIMABLE (GB)" ,
(select ((round(SPACE_USED/1024/1024/1024,2)/ROUND(SPACE_LIMIT/1024/1024/1024,2))*100)  from v$recovery_file_dest) "Percentage Used %",
(select round(ESTIMATED_FLASHBACK_SIZE/1024/1024/1024,2)
from V$FLASHBACK_DATABASE_LOG) "Estimated Space (GB)"
from V$RECOVERY_FILE_DEST;