In Oracle Database, adaptive query optimization enables the optimizer to make runtime adjustments to execution plans and discover additional information that can lead to better statistics.
Adaptive optimization is helpful when existing statistics are not sufficient to generate an optimal plan. The following graphic shows the feature set for adaptive query optimization.
