DBA Data[Home] [Help]

VIEW: SYS.V_$RECOVERY_FILE_DEST

Source

View Text - Preformatted

select "NAME","SPACE_LIMIT","SPACE_USED","SPACE_RECLAIMABLE","NUMBER_OF_FILES","CON_ID" from
   v$recovery_file_dest
View Text - HTML Formatted

SELECT "NAME"
, "SPACE_LIMIT"
, "SPACE_USED"
, "SPACE_RECLAIMABLE"
, "NUMBER_OF_FILES"
, "CON_ID" FROM V$RECOVERY_FILE_DEST