Snapshot Level Database Table Space |
Logical Data Grouping dbase tablespace bp_info |
Monitor Switch Buffer Pool Buffer Pool Buffer Pool |
Resettable |
Yes |
|
Event Type Database Table Space |
Logical Data Grouping db_event tablespace_event |
|
Element Name Element Type |
pool_async_data_read_reqs counter |
Description: The number of asynchronous read requests.
Usage: To calculate the average number of data pages read per asynchronous request, use the following formula:
buffer pool asynchronous data reads / buffer pool asynchronous read requests
This average can help you determine the amount of asynchronous I/O done in each interaction with the prefetcher.