Flash Recovery Area Space Consumption

Flash Recovery Area Space Consumption

SELECT * FROM V$RECOVERY_FILE_DEST;  

NAME            SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES 

--------------  ----------- ---------- ----------------- --------------- 

/mydisk/rcva     5368709120 109240320             256000              28

SELECT * FROM   V$FLASH_RECOVERY_AREA_USAGE;  

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES 

------------ ------------------ ------------------------- --------------- 

CONTROLFILE                   0                         0               0 

ONLINELOG                     2                         0              22 

ARCHIVELOG                 4.05                      2.01              31 

BACKUPPIECE                3.94                      3.86               8 

IMAGECOPY                 15.64                     10.43              66 

FLASHBACKLOG                .08                         0               1