Adaptive serial direct path read decision ignores object statistics since 12.1

(Sayan Malakshinov) On versions 11.2.0.2 – 11.2.0.4 Oracle uses objects’ statistics to make direct path reads decision (of course, if “_direct_read_decision_statistics_driven” haven’t changed it to “false”), and we can force serial direct reads on statement level using sql profiles with hints INDEX_

Read More – Register for a Membership
Read More (Community content)