Data Warehouse Jobs Slow with 'Direct path read' and 'Db file sequential read' Waits
Last updated on APRIL 24, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
- Data warehouse jobs slow with following waits:
Top 5 Timed Events
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
direct path read 10,066,164 618,417 61 32.9 User I/O >>>>>>>>>>>>>>>>>>>>>>top wait events are IO wait events
db file sequential read 12,346,527 399,155 32 21.2 User I/O
PX Deq Credit: send blkd 20,325,278 157,409 8 8.4 Other
db file scattered read 1,907,206 155,578 82 8.3 User I/O
"Avg wait (ms)" column from above section are beyond 10 (ms)> Ideally this should be under 10 (ms), values beyond 10(ms) shows that something may be wrong with IO subsystem.
These values indicate that IO is running slow.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms