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_write_time counter |
Description: The total elapsed time spent writing data or index pages from the buffer pool to disk by database manager page cleaners.
Usage: To calculate the elapsed time spent writing pages synchronously, use the following formula:
total buffer pool physical write time - buffer pool asynchronous write time
You can also use this element to calculate the average asynchronous read time using the following formula:
buffer pool asynchronous write time / (buffer pool asynchronous data writes + buffer pool asynchronous index writes)
These calculations can be used to understand the I/O work being performed.