RMUDISPLAY72.HLB  —  Overview  Fields  Record Statistics screen

1  –  record_marked_field

    This field gives the number of records marked. A record is marked
    when it is modified or it is erased, but not when it is stored.
    This field does not include records modified in a temporary
    table.

2  –  record_fetched_field

    This field gives the number of records, including snapshot
    records. This field does not include records retrieved from a
    temporary table.

3  –  ____fragmented_field_

    This subfield indicates the number of record fragments that
    Oracle Rdb had to fetch. A record is fragmented if it is too
    large to fit on one page. A fragmented record requires more
    CPU time and more virtual memory, and often requires additional
    I/O operations because each record fragment must be fetched. If
    this value is high compared to the number of records fetched,
    Oracle Corporation recommends that you use the RMU Analyze Areas
    command to further analyze the problem to see how many records
    are actually fragmented.

4  –  __record_stored_field

    This field gives the number of records stored in the database.
    This field does not include records stored in temporary tables.

5  –  _____fragmented_field_

    This subfield indicates the number of rows stored as fragmented
    records in the database. This number indicates that a page
    size is smaller than a record's uncompressed size (including
    overhead). You should use the RMU Analyze Areas command to
    further analyze the problem and then increase the page size for
    the storage area that has the problem.

6  –  __pages_checked_field

    This field indicates the number of pages checked in order to
    store a record. Ideally, very few candidate pages need to
    be checked when storing a record. However in certain cases,
    depending on record size, access method, locked space on a page,
    and SPAM thresholds, storing a record requires a number of page
    fetches.

7  –  saved IO field

    This field gives the number of pages checked that did not result
    in an I/O because the page was already in the buffer. It is
    essentially a "for free" pages checked.

8  –  ______discarded_field_

    This field identifies the number of pages checked but discarded
    because the actual free space on that page did not meet the
    physical requirements needed to store a new record.

9  –  record_erased_field

    This field gives the number of records erased from the database.
    This field does not include records erased from temporary
    tables.

10  –  ___fragmented_field

    This subfield indicates the number of fragmented records erased
    from the database.

11  –  temp_record_marked_field

    This field gives the number of records marked in a temporary
    table. A record is marked when it is modified or it is erased,
    but not when it is stored.

12  –  temp_record_fetchd_field

    This field gives the number of records fetched from a temporary
    table.

13  –  temp_record_stored_field

    This field gives the number of records stored in a temporary
    table.

14  –  temp_record_erased_field

    This field gives the number of records erased from a temporary
    table.
Close Help