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_reads counter |
Description: The number of read operations that do not use the buffer pool.
Usage: Use the following formula to calculate the average number of sectors that are read by a direct read:
direct reads from database / direct read 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 reads are performed in units, the smallest being a 512-byte sector. They are used when: