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_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.
[ Top of Page | Table of Contents | Glossary | Index ]