ITPUB
Jun 29, 2016 · Databases
Why Oracle 11g Uses Direct Path Reads for Full Table Scans and How to Tune Them
The article explains how Oracle 11g may bypass the buffer cache with direct path reads during full table scans, lists common causes such as large sorts, hash joins, and parallel queries, and shows how hidden parameters like _serial_direct_read can be adjusted to improve performance.
10g11gDirect Path Read
0 likes · 4 min read