VMS Help  —  RMU72  Load  Database  Command Qualifiers, Statistics
    Statistics=(stat-opts)

    Specifies that statistics are to be displayed at regular
    intervals or each time a transaction commits, or both, so that
    you can evaluate the progress of the load operation.

    The stat-opts are the options you can specify with this
    qualifier, namely: Interval=n, On_Commit, or both. If the
    Statistics qualifier is specified, you must also specify at least
    one option.

    When the Statistics=(Interval=n) qualifier is specified, Oracle
    RMU prints statistics every n seconds. The minimum value for n is
    1.

    When the Statistics=(On_Commit) qualifier is specified, Oracle
    RMU prints statistics each time a transaction is committed.

    If you specify both options, Statistics=(Interval=n, On_Commit),
    statistics are displayed every n seconds and each time a
    transaction commits.

    The displayed statistics include:

    o  Elapsed time

    o  CPU time

    o  Buffered I/O

    o  Direct I/O

    o  Page faults

    o  Number of records loaded when the last transaction was
       committed

    o  Number of records loaded so far in the current transaction

    o  If the Record_Definition=Exception_File option is also
       specified, the following statistics are displayed also:

       -  Number of records rejected when the last transaction was
          committed

       -  Number of records rejected so far in the current
          transaction

    o  If the Parallel qualifier is specified also, the following
       statistics are displayed also:

       -  Number of extra commits performed by executors

          Extra commits are caused when the Oracle RMU directs your
          process or the executors to commit a transaction earlier
          than usual to avoid a hung load operation. For example, if
          one executor is holding, but no longer needs a lock that
          another executor requires, Oracle RMU directs the first
          executor to commit its current transaction. By directing an
          executor or executors to commit a transaction earlier than
          usual, the locks under contention are released and the load
          operation can proceed.

       -  The total number of executors

       -  The number of executors that are initializing, idle,
          terminated, sorting, storing, committing, or executing

    At any time during the load operation, you can press Ctrl/T to
    display the current statistics.
Close Help