Library /sys$common/syshlp/SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  NUMBER_OF_RECOVERY_BUFFERS
    Syntax option:

    NUMBER OF RECOVERY BUFFERS IS number-buffers

    Specifies the number of buffers allocated to the automatic
    recovery process that Oracle Rdb initiates after a system or
    process failure. This recovery process uses the recovery-unit
    journal file (.ruj file extension).

    You can specify any number greater than or equal to 2 and less
    than or equal to 32,767. The default value for the NUMBER OF
    RECOVERY BUFFERS parameter is 20. If you have a large, multifile
    database and you work on a system with a large amount of memory,
    specify a large number of buffers. The result is faster recovery
    time. However, make sure your buffer pool does not exceed the
    amount of memory you can allocate for the pool.

    Use the NUMBER OF RECOVERY BUFFERS option to increase the number
    of buffers allocated to the recovery process.

    SQL> ALTER DATABASE FILENAME personnel
    cont>  NUMBER OF RECOVERY BUFFERS IS 150;

    This option is used only if the NUMBER OF RECOVERY BUFFERS value
    is larger than the NUMBER OF BUFFERS value. For more information
    on allocating recovery buffers, see the Oracle Rdb Guide to
    Database Maintenance.
Close Help