advertisements
_____________________________________________________________________________________________________________________
There are two dictionary views to monitor the flash recovery area usage.
1.
V$RECOVER_FILE_DEST can be used to find out the physical location, allocated space, space reclaimable, number of files present in the directory.
SQL> SELECT * FROM V$RECOVERY_FILE_DEST SQL> / NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES ---------------------------------------- ----------- ---------- ----------------- --------------- /apps/oracle/oradata/FRA 2.1475E+11 9.3252E+10 0 20
2. V$flash_recovery_area_usage can be used to find out percentage of the total disk quota used by different types of files, and how much space for each type of file can be reclaimed by deleting files that are obsolete, redundant, or already backed up to tape.
SQL> set pages 100 SQL> set lines 120 SQL> l 1* SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE SQL> / FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES -------------------- ------------------ ------------------------- --------------- CONTROL FILE 0 0 0 REDO LOG 0 0 0 ARCHIVED LOG 0 0 0 BACKUP PIECE 43.42 0 20 IMAGE COPY 0 0 0 FLASHBACK LOG 0 0 0 FOREIGN ARCHIVED LOG 0 0 0 7 rows selected.
You may like this also:-
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment