Oracle wait event: direct path read

MOS Note 2426051.1 lists two ways to disable direct path reads:

• Set event 10949 to level 1
• Set parameter _serial_direct_read

The note also lists two ways to force direct path reads:

• Using the /*+ parallel */ hint.
• Setting a table's number of block statistics to a higher value than the parameter _small_table_threshold

But also consider the _direct_read_decision_statistics_driven parameter: if its value is true (the default), the decision is based on optimizer statistics, if false, then it is based on the actual block count value in the segment header.

Bypassing the buffer cache with direct path insert and read

direct path insert

Event 10357 (?)

A direct path read is performed by the function kcbldrget

MOS Notes 50415, 2426051.1