监控flash

--监控flash_recovery_area的使用情况(V$FLASH_RECOVERY_AREA_USAGE,V$RECOVERY_FILE_DEST) SYS@PROD1> 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. SYS@PROD1> col name for a45 SYS@PROD1> 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 SYS@PROD1> 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