V$FLASH_RECOVERY_AREA_USAGE

indicate the flash recovery area disk space usage

SQL> desc v$flash_recovery_area_usage;
 名前                                                  NULL?    型
 ----------------------------------------------------- -------- ------------------------------------
 FILE_TYPE                                                      VARCHAR2(12)
 PERCENT_SPACE_USED                                             NUMBER
 PERCENT_SPACE_RECLAIMABLE                                      NUMBER
 NUMBER_OF_FILES                                                NUMBER

使用例:
SQL> select file_type,percent_space_used,percent_space_reclaimable,number_of_files from v$flash_recovery_area_usage;

FILE_TYPE                            PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------------------------------ ------------------ ------------------------- ---------------
CONTROLFILE                                           0                         0               0
ONLINELOG                                             0                         0               0
ARCHIVELOG                                          .19                         0               1
BACKUPPIECE                                           0                         0               0
IMAGECOPY                                             0                         0               0
FLASHBACKLOG                                          0                         0               0

6行が選択されました。

SQL>
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License