Flash Recovery Area

SQL> select space_limit/1024/1024 "Limit MB", space_used/1024/1024 "Used MB",
 space_reclaimable/1024/1024 "Reclaimable MB"
 from v$recovery_file_dest;  2    3  

  Limit MB    Used MB Reclaimable MB
---------- ---------- --------------
     40960 38990        35818

SQL> select * from v$flash_recovery_area_usage;


alter system set db_recovery_file_dest_size=7G scope=both sid='*';