Fast Recovery Area usage

1CLEAR COLUMNS2SET LINESIZE 140 PAGESIZE 100 TRIMOUT ON TAB OFF3COLUMN name           HEADING "LOCATION"       FORMAT A304COLUMN limit_gb       HEADING "LIMIT GB"       FORMAT 999,990.95COLUMN used_gb        HEADING "USED GB"        FORMAT 999,990.96COLUMN reclaimable_gb HEADING "RECLAIMABLE GB" FORMAT 999,990.97COLUMN real_used_pct  HEADING "REAL USED %"    FORMAT 990.98COLUMN files          FORMAT 999,9909COLUMN file_type      HEADING "FILE TYPE"      FORMAT A2510COLUMN used_pct       HEADING "USED %"         FORMAT 990.9911COLUMN reclaim_pct    HEADING "RECLAIM %"      FORMAT 990.9912 13SELECT name,14       ROUND(space_limit / POWER(1024, 3), 1) AS limit_gb,15       ROUND(space_used / POWER(1024, 3), 1) AS used_gb,16       ROUND(space_reclaimable / POWER(1024, 3), 1) AS reclaimable_gb,17       ROUND(100 * (space_used - space_reclaimable) / NULLIF(space_limit, 0), 1) AS real_used_pct,18       number_of_files AS files19FROM v$recovery_file_dest;20 21SELECT file_type,22       percent_space_used AS used_pct,23       percent_space_reclaimable AS reclaim_pct,24       number_of_files AS files25FROM v$recovery_area_usage26ORDER BY percent_space_used DESC;