SQL query to find Flash Recovery Area (FRA) usage

Please find the sql query below to get the used & free size of flash recovery area

Both queries are same. First one gives the output in round integer. Second one gives the exact number.

set lines 1000

col name for a35

col SPACE_LIMIT for a15

col SPACE_AVAILABLE for a15

col SPACE_USED for a15

col SPACE_RECLAIMABLE for a17

SELECT NAME,TO_CHAR(SPACE_LIMIT/1024/1024/1024,'999') AS SPACE_LIMIT,TO_CHAR(SPACE_USED/1024/1024/1024,'999') SPACE_USED,

TO_CHAR(SPACE_LIMIT/1024/1024/1024 - SPACE_USED/1024/1024/1024+ SPACE_RECLAIMABLE/1024/1024/1024,

'999') AS SPACE_AVAILABLE,TO_CHAR(SPACE_RECLAIMABLE/1024/1024/1024,'999') SPACE_RECLAIMABLE,NUMBER_OF_FILES,ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1) 

AS PERCENT_FULL FROM V$RECOVERY_FILE_DEST;

set lines 200

col NAME for a35

SELECT NAME,(SPACE_LIMIT/1024/1024/1024) AS SPACE_LIMIT,SPACE_USED/1024/1024/1024 AS SPACE_USED,

(SPACE_LIMIT/1024/1024/1024) - (SPACE_USED/1024/1024/1024+ SPACE_RECLAIMABLE/1024/1024/1024)

AS SPACE_AVAILABLE,SPACE_RECLAIMABLE/1024/1024/1024 AS SPACE_RECLAIMABLE,NUMBER_OF_FILES,ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1) 

AS PERCENT_FULL FROM V$RECOVERY_FILE_DEST;