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_index_reads counter |
Description: The number of index pages read asynchronously into the buffer pool by a prefetcher.
Usage: You can use this element with "Buffer Pool Index Physical Reads" to calculate the number of physical reads that were performed synchronously (that is, physical index page reads that were performed by database manager agents). Use the following formula:
buffer pool index physical reads - buffer pool asynchronous index reads
By comparing the ratio of asynchronous to synchronous reads, you can gain insight into how well the prefetchers are working. This element can be helpful when you are tuning the num_ioservers configuration parameter (see the Administration Guide).
Asynchronous reads are performed by database manager prefetchers. For information about these prefetchers, see the Administration Guide.