Check FRA usage

SQL> set linesize 150
column name format a35
SELECT NAME,
SPACE_LIMIT/1024/1024/1024 AS SPACE_LIMIT_GB,
SPACE_USED/1024/1024 AS SPACE_USED_MB,
SPACE_RECLAIMABLE/1024/1024 AS SPACE_RECLAIMABLE_MB,
NUMBER_OF_FILES
FROM V$RECOVERY_FILE_DEST;SQL> SQL>   2    3    4    5    6

NAME                                SPACE_LIMIT_GB SPACE_USED_MB SPACE_RECLAIMABLE_MB NUMBER_OF_FILES
----------------------------------- -------------- ------------- -------------------- ---------------
/data/oracle/SHCIPS/flashback                    7    5265.20313                   50             106

SQL> set linesize 150
column name format a35
SELECT NAME,
SPACE_LIMIT/1024/1024/1024 AS SPACE_LIMIT_GB,
SPACE_USED/1024/1024 AS SPACE_USED_MB,
SPACE_RECLAIMABLE/1024/1024 AS SPACE_RECLAIMABLE_MB,
NUMBER_OF_FILES,
ROUND (SPACE_USED * 100 / SPACE_LIMIT) AS FRA_USED_PCT
FROM V$RECOVERY_FILE_DEST;

NAME                                SPACE_LIMIT_GB SPACE_USED_MB SPACE_RECLAIMABLE_MB NUMBER_OF_FILES FRA_USED_PCT
----------------------------------- -------------- ------------- -------------------- --------------- ------------
/data/oracle/SHCIPS/flashback                    7    5265.20313                   50             106           73

SQL> set linesize 180
SQL> select oldest_flashback_scn,
to_char(oldest_flashback_time,'mm/dd/yy hh24:mi:ss') as oldest_flashback_time,
  2    3  retention_target/60 as retention_target_hours,
flashback_size/(1024*1024*1024) as flashback_size_G,
  4    5  estimated_flashback_size/(1024*1024*1024) as estimated_flashback_size_G
from v$flashback_database_log;  6

OLDEST_FLASHBACK_SCN OLDEST_FLASHBACK_ RETENTION_TARGET_HOURS FLASHBACK_SIZE_G ESTIMATED_FLASHBACK_SIZE_G
-------------------- ----------------- ---------------------- ---------------- --------------------------
           294692964 08/22/18 21:08:55                     12       5.14179993                 4.94802475

SQL> set linesize 150
column file_type format a25
SELECT FILE_TYPE,
PERCENT_SPACE_USED,
PERCENT_SPACE_RECLAIMABLE ,
NUMBER_OF_FILES
FROM V$FLASH_RECOVERY_AREA_USAGE;SQL> SQL>   2    3    4    5

FILE_TYPE                 PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------------------- ------------------ ------------------------- ---------------
CONTROL FILE                               0                         0               0
REDO LOG                                   0                         0               0
ARCHIVED LOG                               0                         0               0
BACKUP PIECE                               0                         0               0
IMAGE COPY                                 0                         0               0
FLASHBACK LOG                          73.45                        .7             106
FOREIGN ARCHIVED LOG                       0                         0               0

7 rows selected.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26664718/viewspace-2212625/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26664718/viewspace-2212625/