Oracle FRA ve Archive Log Doluluk Kontrolü

SELECT name,
       ROUND(space_limit / 1073741824, 2)   AS limit_gb,
       ROUND(space_used / 1073741824, 2)    AS used_gb,
       ROUND(space_reclaimable / 1073741824, 2) AS reclaimable_gb,
       ROUND(100 * (space_used - space_reclaimable) / space_limit, 1) AS real_used_pct
FROM   v$recovery_file_dest;

SELECT file_type, percent_space_used, percent_space_reclaimable, number_of_files
FROM   v$recovery_area_usage
ORDER  BY percent_space_used DESC;