Average of number of pages read per async request (AveNumPgsReadPerAsyncReq)

This parameter indicates the average number of data pages that have been read by asynchronous read requests at the buffer pool level. This parameter is helpful in determining how well database data is clustered on the disk. For example, a low average indicates poor data clustering and that a REORG may be necessary.

Default parameter attributes