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.