The number of asynchronous
read requests for index pages.
Table 2. Snapshot
Monitoring InformationSnapshot Level |
Logical Data Grouping |
Monitor
Switch |
Database |
dbase |
Buffer
Pool |
Table Space |
tablespace |
Buffer Pool |
Buffer Pool |
bufferpool |
Buffer Pool |
For snapshot
monitoring, this counter can be reset.
Table 3. Event Monitoring InformationEvent Type |
Logical
Data Grouping |
Monitor Switch |
Database |
event_db |
- |
Tablespaces |
event_tablespace |
- |
- Usage
- To calculate the number of index pages
read per asynchronous
request, use the following formula:
pool_async_index_reads / pool_async_index_read_reqs
This
average can help you determine the amount of asynchronous I/O done
for index pages in each interaction with the prefetcher.