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_writes counter |
Description: The number of write operations that do not use the buffer pool.
Usage: Use the following formula to calculate the average number of sectors that are written by a direct write.
direct writes to database / direct write requests
When using system monitors to track I/O, this data element helps you distinguish database I/O from non-database I/O on the device.
Direct writes are performed in units, the smallest being a 512-byte sector. They are used when: