Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
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(23) 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
CON_ID NUMBER The ID of the container to which the data pertains. Possible values include:
  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data