Which action is taken by the optimizer?

Examine the parameters set for your database instance:

You notice that for one particular SQL statement, the optimizer generates a new better plan
than the plans in theSQL Plan Management Base. Which action is taken by the
optimizer?(Choose the best answer.)

Examine the parameters set for your database instance:

You notice that for one particular SQL statement, the optimizer generates a new better plan
than the plans in theSQL Plan Management Base. Which action is taken by the
optimizer?(Choose the best answer.)

A.
It adds the newly generated plan as an accepted but non-fixed plan.

B.
It adds the newly generated plan as enabled and accepted.

C.
It adds the newly generated plan as enabled but not accepted.

D.
It adds the newly generated plan as a fixed plan, which will be used each time the SQL
statement is executed.



Leave a Reply 7

Your email address will not be published. Required fields are marked *


Larisa

Larisa

From Oracle Database 12c Release 1 onward, automatic plan evolution is done by the SPM Evolve Advisor. The SPM Evolve Advisor is an AutoTask (SYS_AUTO_SPM_EVOLVE_TASK), which operates during the nightly maintenance window and automatically runs the evolve process for unaccepted plans in SPM.

Source: http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-sql-plan-mgmt-12c-1963237.pdf
Plan Evolution and Automatic Plan Evolution

robert

robert

The same document declares:
Regardless of which method you use to initially create a SQL plan baseline, any subsequent new plan found for that SQL statement will be added to the plan baseline as an unaccepted plan. This behavior is not dependent on the initialization parameter OPTIMIZER_CAPTURE_SQL_PLAN_ BASELINES and will occur even if this parameter is set to FALSE (the default).

Larisa

Larisa

According to the documentation mentioned above, I think the answer is B