Database Administration & Monitoring
Histograms on character strings between 11.2.0.3 and 11.2.0.4
30.11.2016 by Oracle Team
By Franck Pachot . In short, when have statistics gathered in 11.2.0.3 but the query is now running with the 11.2.0.4 optimizer, you may have wrong cardinality estimation on histograms, leading to sub-optimal plans.