Saturday, June 07, 2014


The V$RECOVERY_FILE_DEST view shows details about the flash recovery area. In the example below, it is queried to see the maximum size. This is then increased from 4 gigabytes to 5 gigabytes and the view is queried again to see the change: 

ORCL /export/home/oracle > sqlplus / as sysdba
SQL*Plus: Release Production on Tue Jun 18 16:08:48 2013
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> desc v$recovery_file_dest
Name                       Null?    Type
-------------------------- -------- ------------------
NAME                                VARCHAR2(513)
SPACE_LIMIT                         NUMBER
SPACE_USED                          NUMBER
NUMBER_OF_FILES                     NUMBER
SQL> select space_limit
  2  from v$recovery_file_dest
  3  /
SQL> alter system set db_recovery_file_dest_size = 5g
  2  /
System altered.
SQL> select space_limit
  2  from v$recovery_file_dest
  3  /

If you click on the two images below to enlarge them and bring them into focus, you will see that in version 11.1, Oracle called it the flash recovery area:

... whereas in Oracle 11.2, it was called the fast recovery area:

No comments: