Archivelog space usage query

Archivelog space usage query

The folliwng query will give the usage details of FRA.

COLUMN DUMMY NOPRINT
COMPUTE SUM OF percent_space_used ON DUMMY
COMPUTE SUM OF number_of_files ON DUMMY
COMPUTE SUM OF percent_space_reclaimable ON DUMMY
BREAK ON DUMMY
SELECT null dummy, file_type, number_of_files,percent_space_used, percent_space_reclaimable
FROM v$flash_recovery_area_usage
order by 4 desc;