Direct Read Time


 
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_read_time
counter

 

Description:  The elapsed time (in milliseconds) required to perform the direct reads.

Usage:  Use the following formula to calculate the average direct read time per sector:

 
 direct read time / direct reads from database

A high average time may indicate an I/O conflict.