This screen provides summary record access information for all processes activated to collect global statistics using the Process Monitoring facility. The processes displayed on this screen have previously activated their global statistics collection. Process global statistic collection can be either implicitly activated by the database monitor, or explicitly activated by the RMU Show Statistic utility. This screen provides the following information: o Process.ID The process ID for the current process, assigned by the operating system, and the stream ID, assigned by the database. If "G" is appended to the process ID, the process had been activated for global statistics collection; this is the normal case. Server processes will be designated with the "s" tag. o SnpRecRtrv This field gives the number of records retrieved by read-only transactions. o SnpLinFtch This field gives the number of lines fetched by read-only transactions. To retrieve a single record, a transaction might actually check a number of lines, some of which may be empty. o SnpPagRead This field gives the number of snapshot pages fetched by read- only transactions. If this count is high relative to the other read fields, read-only transactions are fetching records that are being updated frequently, and the snapshot file is being used extensively. o SnpRecStor This field gives the number of records stored in the snapshot file by update transactions. Every snapshot record stored by an update transaction implies that a snapshot page was found and utilized. In the best case, this is a single-page fetch. The "page in use," "page too full," page conflict," and "extended file" subfields indicate some of the extra overhead involved in finding suitable snapshot pages on which to store snapshot records. o SnpPagFull This field gives the number of pages fetched that were unsuitable for storing snapshot records because there was not enough room on the snapshot page to include another version of a record. In this case, a new snapshot page must be fetched and linked with the full page. This allows read- only transactions to follow a chain of snapshot pages to find the correct version of a record. o SnpLckCnft This field gives the number of times a snapshot page fetch was requested but aborted due to a lock conflict with another process. When a page fetch conflicts with another process, another target page is fetched and checked so the lock conflict does not cost a disk I/O operation.