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