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.