Snapshot Level Database Table Space Application |
Logical Data Grouping dbase tablespace bp_info appl |
Monitor Switch Buffer Pool Buffer Pool Buffer Pool Buffer Pool |
Resettable |
Yes |
|
Event Type Database Table Space Connection |
Logical Data Grouping db_event tablespace_event conn_event |
|
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".