A、It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans. B、The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline. C、It adds new, bettor plans automatically as fixed plans to the baseline. D、The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans. E、The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
A、If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb. B、In a PDB plan, subplans may be used with up to eight consumer groups. C、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb. D、If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated. E、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
A、The plan baselines are verified with the SQL profiles. B、All fixed plan baselines are converted into nonfixed plan baselines. C、All the nonaccepted SQL profiles are accepted into the plan baseline. D、The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.