FRA usage can be checked from V$FLASH_RECOVERY_AREA_USAGE
SQL> SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE 0 0 0
REDO LOG 2.49 0 6
ARCHIVED LOG 45.66 45.31 171
BACKUP PIECE 25.29 0 11
IMAGE COPY 0 0 0
FLASHBACK LOG 4.98 0 12
FOREIGN ARCHIVED LOG 0 0 0
7 rows selected.
SQL>
No comments:
Post a Comment