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_reads counter |
Description: The number of pages read asynchronously into the buffer pool.
Usage: You can use this element with "Buffer Pool Data Physical Reads" to calculate the number of physical reads that were performed synchronously (that is, physical data page reads that were performed by database manager agents). Use the following formula:
buffer pool data physical reads - buffer pool asynchronous data 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.
[ Top of Page | Table of Contents | Glossary | Index ]