Snapshot Information Level Database Table Space Application |
API Structure(s) sqlm_dbase sqlm_tablespace sqlm_bp_info sqlm_appl |
Monitor Group Buffer Pool Buffer Pool Buffer Pool Buffer Pool |
Resettable |
Yes |
|
Event Information Level Database Table Space Connection |
API Structure(s) sqlm_db_event sqlm_tablespace_event sqlm_conn_event |
|
API Element Name Element Type |
pool_read_time counter |
Description: Provides the total amount of elapsed time spent processing read requests that caused data or index pages to be physically read from disk to buffer pool.
Usage: You can use this element with "Buffer Pool Data Physical Reads" and "Buffer Pool Index Physical Reads" to calculate the average page-read time. This average is important since it may indicate the presence of an I/O wait, which in turn may indicate that you should be moving data to a different device.
At the database and table space levels, this element includes the value of "Buffer Pool Asynchronous Read Time".
[ Top of Page | Table of Contents | Glossary | Index ]