Oracle 11g: How to define the fast recovery area

The initialization parameters used to define the Fast Recovery Area are:
-DB_RECOVERY_FILE_DEST : Location of the FRA
-DB_RECOVERY_FILE_DEST_SIZE : Size limit of the FRA

The size of the FRA is mandatory when the DB_RECOVERY_FILE_DEST parameter is defined.

remark: An alert is issued in the alert_log file when 85% of the space is filled. A critical alter is issued when 97% of the space is filled. These thresholds could not be configured.

It is possible to display these alerts using the dba_outstanding_alerts.

SQL> SELECT object_type, message_type, message_level, reason, suggested_action
FROM dba_outstanding_alerts;