V$FLASH_RECOVERY_AREA_USAGE displays usage information about flashback recovery areas.
| Column | Datatype | Description |
|---|---|---|
FILE_TYPE |
VARCHAR2(12) |
File type |
PERCENT_SPACE_USED |
NUMBER |
Percent of recovery area that is in use |
PERCENT_SPACE_RECLAIMABLE |
NUMBER |
Percent of recovery area that is reclaimable |
NUMBER_OF_FILES |
NUMBER |
Number of files in the recovery area |