Snapshot Level Database Table Space Application |
Logical Data Grouping dbase tablespace bp_info appl |
Monitor Switch Buffer Pool Buffer Pool Buffer Pool Buffer Pool |
Resettable |
Yes |
|
Event Type Database Connection Table Space |
Logical Data Grouping db_event conn_event tablespace_event |
|
Element Name Element Type |
direct_write_time counter |
Description: The elapsed time (in milliseconds) required to perform the direct writes.
Usage: Use the following formula to calculate the average direct write time per sector:
direct write time / direct writes to database
A high average time may indicate an I/O conflict.