The 198 record provides most of the access information we need, with the exception of Dynamic Prefetch activity. It doesn’t tell us about read activity, or how many pages were actually brought in by a prefetch read.

It is quite important to understand that the first Getpage (GP) for a prefetched block could be ‘miss’, but the next 31 will absolutely be hits. This creates, at worst, an application hit ratio of 97%. It also doesn't tell us how long the application might have waited for the prefetch to complete. For our purposes in this presentation we are not concerned with I/O wait or elapsed times, although can easily be calculated from the 6 & 7 records.

Note the DBID and OBID in this record and the next two records. This must be translated to a NAME for it to make sense. Therefore, we also need a ‘105’ trace record, or must query the catalog to match the trace records to a useful object name.