Snapshot Information Level Database Table Space |
API Structure(s) sqlm_dbase sqlm_tablespace sqlm_bp_info |
Monitor Group Buffer Pool Buffer Pool Buffer Pool |
Resettable |
Yes |
|
Event Information Level Database Table Space |
API Structure(s) sqlm_db_event sqlm_tablespace_event |
|
API 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.
[ Top of Page | Table of Contents | Glossary | Index ]