VMS Help  —  RMU72  Dump  After journal, Command Qualifiers, Option
    Option=Statistics
    Option=Nostatistics

    The Option=Statistics qualifier specifies that you want Oracle
    RMU to include statistics on how frequently database pages are
    referenced by the data records in the .aij file. In addition, if
    the database root file is available, the output created by the
    Options=Statistics qualifier includes the value to specify for
    the Aij_Buffers qualifier of the RMU Recover command. If several
    .aij files will be used in your recovery operation, perform an
    RMU Dump After_Journal on each .aij file and add the recommended
    Aij_Buffer values. Use the total as the value you specify with
    the Aij_Buffers qualifier. See Example 2 in the Examples help
    entry under this command for an example using this qualifier.

    Note that the value recommended for the RMU Recover command's
    Aij_Buffers qualifier is the exact number of buffers required
    by the data records in the specified .aij file. If you specify
    fewer buffers, you may see more I/O, but you will not necessarily
    see performance degrade. (Performance also depends on whether
    asynchronous batch-writes are enabled.)

    Using more buffers than are recommended may result in your
    process doing more paging than required, and if so, performance
    degrades.

    If you specify the recommended value, note that this does not
    mean that no buffers are replaced during the recovery operation.
    The Oracle RMU buffer replacement strategy is affected by
    whether asynchronous prefetches and asynchronous batch-writes are
    enabled, and on the contents of the buffers before the recovery
    operation begins.

    If the database root file is not available, the Option=Statistics
    qualifier does not provide a value for the RMU Recover command's
    Aij_Buffers qualifier. However, it does provide the statistics on
    the frequency with which each page is accessed.

    Specify the Option=Nostatistics qualifier to suppress .aij
    statistics generation.

    The default for the RMU Dump After_Journal command is
    Option=Statistics.
Close Help