11g Optimizer Plan Stabilty using SQL Plan Baselines
In Oracle 11g, we can ensure that the same proven execution plans are used by the Optimizer regardless of any change which can effect the optimizer like a version change, index drop or recreate, init.ora parameter change etc. Once plans are marked as enabled and accepted, the optimizer will not use any new plans unless […]