--监控flash_recovery_area的使用情况(V$FLASH_RECOVERY_AREA_USAGE,V$RECOVERY_FILE_DEST)
[email protected]> 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 0 0 0
ARCHIVED LOG 5 0 5
BACKUP PIECE 41.8 1.38 17
IMAGE COPY 0 0 0
FLASHBACK LOG 13.34 0 11
FOREIGN ARCHIVED LOG 0 0 0
7 rows selected.
[email protected]> col name for a45
[email protected]> select * from V$RECOVERY_FILE_DEST;
NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE
--------------------------------------------- ----------- ---------- -----------------
NUMBER_OF_FILES
---------------
/u01/app/oracle/fast_recovery_area/ 4322230272 2652056064 59858432
34
[email protected]> select round(100*(a.space_used/space_limit),2) from v$recovery_file_dest a;
ROUND(100*(A.SPACE_USED/SPACE_LIMIT),2)
---------------------------------------
62.57