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_read_time counter |
Description: The total elapsed time spent reading by database manager prefetchers.
Usage: You can use this element to calculate the elapsed time for synchronous reading, using the following formula:
total buffer pool physical read time - buffer pool asynchronous read time
You can also use this element to calculate the average asynchronous read time using the following formula:
buffer pool asynchronous read time / buffer pool asynchronous data reads
These calculations can be used to understand the I/O work being performed.
[ Top of Page | Table of Contents | Glossary | Index ]