SET LINES 132
SELECT file_type
, round(space_limit*percent_space_used/100/1024/1024,0) used_mb
, round(percent_space_used,0) used_pct
, round(space_limit*percent_space_reclaimable/100/1024/1024,0) reclaimable_mb
, round(percent_space_reclaimable,0) reclaimable_pct
, frau.number_of_files num_of_files
FROM v$recovery_file_dest rfd, v$flash_recovery_area_usage frau
UNION ALL
SELECT '** Total **'
, round(space_used/1024/1024,0)
, round(100*space_used/space_limit,0)
, round(space_reclaimable/1024/1024,0)
, round(100*space_reclaimable/space_limit,0)
, number_of_files
FROM v$recovery_file_dest rfd;