Snapshot Information Level Database Table Space Application |
API Structure(s) sqlm_dbase sqlm_tablespace sqlm_bp_info sqlm_appl |
Monitor Group Buffer Pool Buffer Poo Buffer Pooll 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_write_time counter |
Description: Provides the total amount of time spent physically writing data or index pages from the buffer pool to disk.
Usage: You can use this element with "Buffer Pool Data Writes" and "Buffer Pool Index Writes" to calculate the average page-write 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 Write Time".
[ Top of Page | Table of Contents | Glossary | Index ]