The following keywords may be used with the Options qualifier:

    o  [No]All

       Indicates whether or not all collectible statistics (all
       statistics for all areas) are to be collected. The All option
       indicates that all statistics information is to be collected;
       the Noall keyword indicates that only the base statistics
       information is to be collected. You must also specify the
       Output qualifier. Note: Logical Area information is not
       written to the binary output file.

    o  [No]Area

       Indicates whether or not the by-area statistics information
       is to be collected in addition to the base statistics
       information. When you specify the Area or Noarea option, the
       Base statistics are implicitly selected. You must also specify
       the Output qualifier.

       When the Area option is specified, statistics for all existing
       storage areas are written to the binary output file; you
       cannot selectively choose specific storage areas for which
       statistic information is to be collected.

       The size of the by-area statistics output largely depends on
       the total number of storage areas in the database, including
       reserved storage areas. If the database contains a large
       number of storage areas, it may not be advisable to use the
       Options=Area qualifier.

       Before you replay a binary output file that contains by-
       area statistics, specify the following command to format the
       display correctly:

       $ SET TERM/NOTAB

       You can then replay the statistics as follows:

       $ RMU/SHOW STATISTICS/INPUT=main.stats

    o  Base (default)

       Indicates that only the base set of statistics is to be
       collected; this is the default Options option. The base set of
       statistics is identical to the one collected prior to Oracle
       Rdb V6.1. You must also specify the Output qualifier. You
       cannot specify Nobase.

    o  Compress

       Compresses the statistics records written to the output
       file specified by the Output qualifier. While replaying the
       statistics, the RMU Show Statistics command determines if a
       record was written using compression or not. If the record was
       written using compression it is automatically decompressed.

       If compression is used, the resultant binary file can be
       read only by the RMU Show Statistics command. The format and
       contents of a compressed file are not documented or accessible
       to other applications.

    o  Confirm

       Indicates that you wish to confirm before exiting from the
       utility. You can also specify the Confirm option in the
       configuration file using the CONFIRM_EXIT variable. A value
       of TRUE indicates that you want to confirm before exiting the
       utility and a value of FALSE (the default) indicates you do
       not want to confirm before exiting the utility.

    o  Log_Stall_Alarm

       If Log_Stall_Alarm is present when using the Stall_Log
       qualifier to write stall messages to a log file and the
       Alarm qualifier to set an alarm interval, only those stalls
       exceeding the Alarm specified duration are written to the
       stall log output file.

    o  Log_Stall_Lock

       If you use the Stall_Log qualifier to write stall messages to
       a log file, use the Nolog_Stall_Lock option to prevent lock
       information from being written to the log file. If you use or
       omit the Log_Stall_Lock option, lock information is written to
       the log file.

    o  [No]Row_Cache

       Indicates that all row cache related screens and features of
       the RMU Show Statistics facility are to be displayed. NoRow_
       Cache indicates that these features are disabled.

    o  Screen_Name

       Allows you to identify a screen capture by screen name. If you
       issue an RMU Show Statistics command with the Options=Screen_
       Name qualifier, the screen capture is written to a file that
       has the name of the screen with all spaces, brackets, and
       slashes replaced by underscores. The file has an extension of
       .SCR. For example, if you use the Option=Screen_Name qualifier
       and select the Write option on the Screen Transaction
       Duration (Read/Write), the screen is written to a file named
       TRANSACTION_DURATION_READ_WRITE.SCR.

    o  Update

       Allows you to update fields in the Database Dashboard. See
       the Performance Monitor Help or the Oracle Rdb7 Guide to
       Database Performance and Tuning for information about using
       and updating the Database Dashboard. You must have both the
       OpenVMS WORLD and BYPASS privileges to update fields in the
       Database Dashboard.

    o  Verbose

       Causes the stall message logging facility to report a stall
       message at each interval, even if the stall message has been
       previously reported.

                                      NOTE

          Use of the Options=Verbose qualifier can result in an
          enormous stall messages log file. Ensure that adequate
          disk space exists for the log file when you use this
          qualifier.

       You can enable or disable the stall messages logging Verbose
       option at run time by using the Tools menu and pressing the
       exclamation point (!) key.

       You can also specify the Verbose option in the configuration
       file by using the STALL_LOG_VERBOSE variable. Valid keywords
       are ENABLED or DISABLED.

       Lock information is displayed only once per stall, even in
       verbose mode, to minimize the output file size.