V$RECOVERY_FILE_DEST select location, -- NAME VARCHAR2(513) slimit, -- SPACE_LIMIT NUMBER (sused + scfile), -- SPACE_USED NUMBER srecl, -- SPACE_RECLAIMABLE NUMBER fcnt -- NUMBER_OF_FILES NUMBER from x$kccrdi