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