First page Back Continue Last page Graphics
...Flash Recovery Area: Monitoring
V$FLASH_RECOVERY_AREA_USAGE
Notes:
Oracle10g Release 2 provides another dynamic performance view, V$FLASH_RECOVERY_AREA_USAGE. This view records space used by file type, where the file type can be CONTROLFILE, ONLINELOG, ARCHIVELOG, BACKUPPIECE, IMAGECOPY, FLASHBACKLOG. The PERCENT_SPACE_USED is the percentage of the total space as reported by V$RECOVERY_FILE_DEST.SPACE_USED.