User Tools

Site Tools


adaptiveplans

This is an old revision of the document!


Adaptive Plans

Adaptive Plans in Oracle Database 12c allow runtime changes to execution plans.
At runtime the cardinality of operations is checked using statistics collectors and compared to the cardinality estimates used to generate the execution plan. If the cardinality of the operation is not as expected, an alternative subplan can be used.

adaptiveplans.1437571417.txt.gz · Last modified: 2025/03/08 22:23 (external edit)