VIEW: SYS.V_$RECOVERY_AREA_USAGE

Source

View Text - Preformatted

select "FILE_TYPE","PERCENT_SPACE_USED","PERCENT_SPACE_RECLAIMABLE","NUMBER_OF_FILES","CON_ID" from
   v$recovery_area_usage

View Text - HTML Formatted

SELECT "FILE_TYPE"
, "PERCENT_SPACE_USED"
, "PERCENT_SPACE_RECLAIMABLE"
, "NUMBER_OF_FILES"
, "CON_ID" FROM V$RECOVERY_AREA_USAGE