监控flash_recovery_area的使用情况(V$FLASH_RECOVERY_AREA_USAGE,V$RECOVERY_FILE_DEST)

来源：互联网发布：视频慢放编辑软件编辑：程序博客网时间：2024/06/05 06:41

--监控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 00REDO LOG      0 00ARCHIVED LOG      5 05BACKUP PIECE   41.8      1.38       17IMAGE COPY      0 00FLASHBACK LOG  13.34 0       11FOREIGN ARCHIVED LOG      0 007 rows selected.SYS@PROD1> col name for a45SYS@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

0 0