Oracle [ db_recovery_file_dest_size ]

SQL> SELECT * FROM V$RECOVERY_FILE_DEST;

NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
------------------------------------------------------------ ----------- ---------- ----------------- ---------------
/u01/app/oracle/FLASH_RECOVERY_AREA 3.2212E+10          0                 0               0


SQL> show parameter db_recovery_file_dest_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size           big integer 30G

SQL> alter system set db_recovery_file_dest_size=100G;

System altered.


SQL> show parameter db_recovery_file_dest_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size           big integer 100G