Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$RECOVERY_AREA_USAGE

V$RECOVERY_AREA_USAGE displays usage information about recovery areas.

Column Datatype Description
FILE_TYPE VARCHAR2(20) File type:
  • CONTROL FILE

  • REDO LOG

  • ARCHIVED LOG

  • BACKUP PIECE

  • IMAGE COPY

  • FLASHBACK LOG

  • REMOTE ARCHIVED LOG

PERCENT_SPACE_USED NUMBER Percent of the recovery area that is in use
PERCENT_SPACE_RECLAIMABLE NUMBER Percent of the recovery area that is reclaimable
NUMBER_OF_FILES NUMBER Number of files in the recovery area