RMUDISPLAY72.HLB  —  Overview  Fields  PIO Statistics Data Writes screen

1  –  unmark_buffer_field

    This field is incremented by one each time a modified buffer is
    written back to disk. Its value should be equal to the sum of
    the 14 following fields. These fields as well as the SPAM page
    field provide further detail about buffer unmark activity. Write
    operations of buffers that contain SPAM pages are included in the
    total although they are also counted separately by the SPAM page
    field.

    Note that unmarking one buffer may entail more than one I/O.

2  –  __transaction_field

    This field is incremented by one for each modified buffer that
    is written back to disk as a result of a COMMIT or ROLLBACK
    statement.

3  –  __pool_overflow_field

    This field is incremented by one for each modified buffer that
    is written back to disk as a result of a request to read in a new
    page from disk.

4  –  blocking AST field

    This field is incremented by one for each modified buffer that
    is written back to disk in response to a blocking AST (that is, a
    page in the buffer was requested by another user).

5  –  __lock_quota_field

    This field is incremented by one for each modified buffer that is
    written back to disk due to a user reaching his lock quota.

6  –  __lock_conflict_field

    This field is incremented by one for each modified buffer that is
    written back to disk to reduce the possibility of a deadlock when
    Oracle Rdb discovers a lock conflict.

7  –  __user_unbind_field

    This field is incremented by one for each modified buffer that is
    written back to disk as a result of a user's detaching from the
    database. This includes database detaches that occur as part of
    an Oracle RMU operation.

8  –  __batch_rollback_field

    This field is incremented by one for each modified buffer that
    is written back to disk because of a failed or rolled back batch-
    update transaction.

9  –  __new_area_mode_field

    This field is incremented by one for each modified buffer that is
    written back to disk as a result of a physical area being readied
    in a new lock mode.

10  –  __larea_change_field

    This field is incremented by one for each modified buffer that
    is written back to disk as a part of creating, deleting, or
    extending a logical area.

11  –  __incr_backup_field

    This field is incremented by one for each modified buffer that
    is written back to disk to support the requirements of the
    incremental backup feature. These buffers are always SPAM page
    buffers.

12  –  no AIJ access field

    This field is incremented by one for each modified buffer that
    is written back to disk as a safety precaution after the failure
    of an I/O to the .aij file. The buffers are unmarked under such
    circumstances only when fast commit processing is enabled to
    ensure that all committed data is safely in the database.

13  –  __truncate_snaps_field

    This field is incremented by one for each modified buffer that
    is written back to disk as a part of an online snapshot file
    truncation.

14  –  __checkpoint_field

    This field is incremented by one for each modified buffer that is
    written back to disk as a result of a checkpoint.

15  –  AIJ backup field

    This field is incremented by one for each modified buffer that
    is written back to disk to optimize the performance of the quiet-
    point backup of the .aij file.
Close Help