Identify the correct sequence of steps.

The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan
evolution task manually. Examine the following steps: 1.Set the evolve task parameters.
2.Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.
3.Implement the recommendations in the task by using the
DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 4.Execute the evolve task by using
the DBMS_SPM.EXECUTE_EVOLVE_TASK function. 5.Report the task outcome by using
the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps.

The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan
evolution task manually. Examine the following steps: 1.Set the evolve task parameters.
2.Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.
3.Implement the recommendations in the task by using the
DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 4.Execute the evolve task by using
the DBMS_SPM.EXECUTE_EVOLVE_TASK function. 5.Report the task outcome by using
the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps.

A.
2, 4, 5

B.
2, 1, 4, 3, 5

C.
1, 2, 3, 4, 5

D.
1, 2, 4, 5

Explanation:

Show Hint

Leave a Reply 2

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

srks

srks

A – please crosscheck

Manually Evolving SQL Plan Baselines

In previous releases, evolving SQL plan baselines was done using the EVOLVE_SQL_PLAN_BASELINE function. In 12c this has been replaced by a task-based approach, which typically involves the following steps.

CREATE_EVOLVE_TASK
EXECUTE_EVOLVE_TASK
REPORT_EVOLVE_TASK
IMPLEMENT_EVOLVE_TASK

Reply