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.