监控flash_recovery_area的使用情况

监控flash_recovery_area的使用情况可以查询2个视图: 1.V$FLASH_RECOVERY_AREA_USAGE:displays usage information about flashback recovery areas  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                                0                           0                 0
ARCHIVED  LOG                        30.81                           0                61
 BACKUP  PIECE                           0                           0                 0
 IMAGE  COPY                             0                           0                 0
FLASHBACK  LOG                       12.99                        8.54                70
 FOREIGN  ARCHIVED  LOG                    0                           0                 0

已选择7行。

SQL >   select   sum (PERCENT_SPACE_USED)  from  v$flash_recovery_area_usage;

 SUM (PERCENT_SPACE_USED)
 -- ---------------------
                     43.8
2.V$RECOVERY_FILE_DEST:displays information about the disk quota and current disk usage in the flash recovery area.
 SQL >   select   *   from  V$RECOVERY_FILE_DEST;

NAME                                     SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
 -- -------------------------------------- ----------- ---------- ----------------- ---------------
 / opt / oracle / flash_recovery_area            8589934592   3762538496           733315072               131

SQL >   select   round ( 100 * (a.space_used / space_limit), 2 )  from  v$recovery_file_dest a;

 ROUND ( 100 * (A.SPACE_USED / SPACE_LIMIT), 2 )
 -- -------------------------------------
                                     43.8