FRA Utilization

set linesize 500  

col NAME for a50  

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(ESTIMATED_FLASHBACK_SIZE/1024/1024/1024,2)   

from V$FLASHBACK_DATABASE_LOG) "Estimated Space (GB)"  

from V$RECOVERY_FILE_DEST;